Queue database exports

**{=OR(value=array)}** · 04-03-2014, 11:44 AM

Hi,

Beginner Access user here. I need to export multiple tables to excel files (separate files). It takes awhile, and in the meantime I can't do anything. I was wondering if there is a way to set it up so access will automatically export all of the tables individually while I go out for a walk.

Thanks,

**alansidman** · 04-04-2014, 01:37 PM

Yes, but it will have to be done using VBA. You will have to write a DoCmd.TransferSpreadsheet line for each table or if you have a list of the tables in another table, then you could write a Do Loop to cycle through that particular table and export each of the named tables.

**maw230** · 04-10-2014, 11:07 AM

I don't think you would have to use VBA as there are some options with built in macros that should work depending on your Access version. For example, Access 2010 and probably 07 has a "ExportWithoutFormatting" command that should work. VBA is generally preferred though.