Exporting Table to excel

[navi95]

Hello All!

I have created a database which is mean to export data to excel, this all works fine on my system where I have office installed fully.
But on the clients PC, he does not have Office, I installed Access runtime in order for the database to operate but it seems like the database doesnt want to export to an Excel file as office isnt fully installed?
Is that why? Would changing the output format to say HTML solve my issue?

Thanks for any input

 

[boerbende]

I am not sure HOW you export to Excel, but what I usually need is the
"Microsoft Excel 14.0 Object library"

How to configure:

Database tools
Visual basic
Tools
References
Select
Microsoft Excel 14.0 Object library

Check if you need to configure that

 

[navi95]

Strangely enough when I got home I tried to reopen the database in order to make changes and to see if HTML format would work best, but the darn thing wouldnt open on my PC with office installed.
I remembered I changed the filename when I took the database to my Client...I changed the name back and it opened!
I have no idea how this happend, somehow the filename of the database is currently linked to my AutoExec macro. hmm.

 

[navi95]

I am not sure HOW you export to Excel, but what I usually need is the
"Microsoft Excel 14.0 Object library"

How to configure:

Database tools
Visual basic
Tools
References
Select
Microsoft Excel 14.0 Object library

Check if you need to configure that

Im using the following VBA code:

DoCmd.OutputTo acOutputTable, "Kunden", acFormatXLSX, "e:\pizza program\kunden.xlsx"

So that will output my table called "Kunden" into a *.XLSX file into the above directory.