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)

 

[Pat Hartman]

You need to look for automation code. Access has to enstantiate Excel and work with the Excel object model to take data and place it into particular cells. Depending on how much data you need to push to Excel and how consistant the data is, it might be easier to use TransferSpreadsheet to export the data to a new sheet and then have the template reference the data sheet rather than trying to post into the template. The advantage to this method in addition to eliminating the automation code is that it is less likely to run into problems should the template need to be changed.