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
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