By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,251 Members | 2,727 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,251 IT Pros & Developers. It's quick & easy.

Transfering data to excel, Excel gives a format error

100+
P: 443
I've build a query that I then transfer to Excel using the docmd.TransferSpreadsheet the transfer works just fine, but when I open the file in Excel (2007) I get a error saying the file is in a different format than specified by the extension .xls I have an option to open the file anyway and it comes up just fine. My problem is the person who will be using the program has excel 2003 and when I try and open the file all I get is garbage.
Hopefully someone has an answer I hope.
Thanks for any help.
PS. I've tried all the acSpreadsheettypeExcel? options and get the same results.
Oct 26 '10 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.