When I use SELECT...INTO to create an Excel 97 file, all is fine.
However, when I use INSERT INTO to place the same records in an Excel range, the numbers are all converted to characters in the Excel worksheet.
The code I used was:-
INSERT INTO MyRange
IN 'D:\Dept\HeadCount.xls' "EXCEL 8.0;"
SELECT *
FROM HeadCount
I have even tried Nz(Accounts,0) as Accounts_, Nz(HR,0) as HR_ etc. in the SELECT clause. But the problem persists.
Does anyone know how to solve this problem? Thanks.
However, when I use INSERT INTO to place the same records in an Excel range, the numbers are all converted to characters in the Excel worksheet.
The code I used was:-
INSERT INTO MyRange
IN 'D:\Dept\HeadCount.xls' "EXCEL 8.0;"
SELECT *
FROM HeadCount
I have even tried Nz(Accounts,0) as Accounts_, Nz(HR,0) as HR_ etc. in the SELECT clause. But the problem persists.
Does anyone know how to solve this problem? Thanks.