exporting text file to excel

sportsguy

Finance wiz, Access hack
Local time
Today, 03:01
Joined
Dec 28, 2004
Messages
363
I need to export a large text file to excel, as sequel server can't read the text file due to some unrecognizable character issues from oracle

I am using acSpreadsheetTypeExcel12Xml in the VBA code, and the file exports with no lines visible in excel. . .

acSpreadsheetTypeExcel12 gives an error as well. . .

its about 400,000 rows of data only

any suggestions?

thanks in advance

sportsguy
 
What version of Access are you using? Show your whole code for exporting.
 
i found the answer:

the enumeration is not accurate,
Instead of acSpreadsheetTypeExcel12, i used 10 and all works fine. .

there is an undocumented feature with the Access07 enumeration!

sportsguy
 

Users who are viewing this thread

Back
Top Bottom