Access to Excel (Access97)

Topic

New Reply

Some days I just can’t stay away from this forum:)

I need to save Access table as in Excel format to a directory.
I am trying TransferText etc and it asks to create specifications – I don’t understand how.

So I decided to use Save as but format gets screwed…anyway if you can just tell me what method is the best to use?

Thanks

Reply | Quote

Replies

Do you want to export manually, or using code?

Manually, you would use File | Save As/Export…

In code, you would use DoCmd.TransferSpreadsheet, not TransferText (that is for text files). The instruction looks like this:

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel97, “tblSomething”, “C:TestExport.xls”, True

Reply | Quote

Thank you so much

Reply | Quote