Export all tables to 1 excel file

[vestlink]

Hi.

Forgive me if this question has been asked before, but i couldn't find any solutions here or in Google. If it has please guide me to the solution :-)

I'd like to export all my tables in a Access 2007 db to one Excel-file where every table name should be the excel tab name. The first row should represent the column names.

I'm a total newbie at this :-(

Hope you can help me out on this.

Best regards,

Nicolai

[rpeare]

Have you looked at the transferspreadsheet command line?

docmd.transferspreadsheet

if you do that it and hit space it will bring up a hint box that shows you the format it expects for exporting a table to an excel spreadsheet, you just have to fill in the variable names, just be aware that the very last variable will be your worksheet name and you have to follow it with a $ mark or it will try to export all of your tables to the same worksheet

[ajetrumpet]

Hi.

Forgive me if this question has been asked before, but i couldn't find any solutions here or in Google. If it has please guide me to the solution :-)

I'd like to export all my tables in a Access 2007 db to one Excel-file where every table name should be the excel tab name. The first row should represent the column names.

I'm a total newbie at this :-(

Hope you can help me out on this.

Best regards,

Nicolai

some genius once wrote this FAQ, long ago:

http://www.access-programmers.co.uk/...d.php?t=191123

I wonder if it still works...

[vestlink]

some genius once wrote this FAQ, long ago:

http://www.access-programmers.co.uk/...d.php?t=191123

I wonder if it still works...

Thank you for your answer :-)

I pasted the code in the general tab, but it didn't seem to have any effect. No errors though.

Am I missing something when it comes to running the code?

[ajetrumpet]

Am I missing something when it comes to running the code?

Probably. I doubt it's verbatim. You know that's it's Access code right? "general tab" confuses me.

[vestlink]

My problem is propably that i don't know how to run the code from access.

Thus, I'm a total newbie and prob also a nobk :-)

In the light of that i'd appreciate something like a step-by-step kinda thing


Nicolai