Export Access to EXCEL with some unique twists

[eblieb]

I need to export data from multiple access tables into a single Excel template.

The template already exists but has more columns then the access database and the data has to skip some columns.

Say columns are A B C D E F G
I need to take data from an access table and put that data into A B C D F G
Then I have another access table that I need to put that data into A B C E F G
and so on and so on

Is there a way to do this?

 

[pwbrown]

Simple answer is yes, you can export to certain ranges into excel. A lot of people have had similar problems lately, have a look on the site and you should find some good starting points. If you can't find anything I'll have a look tomorrow if no one helps before then.

 

[eblieb]

Simple answer is yes, you can export to certain ranges into excel. A lot of people have had similar problems lately, have a look on the site and you should find some good starting points. If you can't find anything I'll have a look tomorrow if no one helps before then.

I decided to go a different direction and am just creating 0s for the columns that I don't need the data in... Now I just have to export it to a template.

I can't find a good example of exporting a table to an already existing excel file and set it to start at row (say 12)