Trying to import a CSV file

[itm]

Hi,
I have SQL code that would import an Excel file as follows:

 Str = "SELECT [Ed_TEST$].* INTO [tblAct_Import_File] FROM [Ed_TEST$] IN '" & impFile & "' [Excel 8.0; HDR = YES;];"
     cn.Execute Str

I do not want to use do not want to use "DoCmd.TransferSpreadsheet" I am finding do to rounding some figures are braught in a little off. However, I have found that if I use code, in the past, this sort of thing does not happen; but I canot remember how to do this. Can someone please tell me how this is done.


Thank you
itm

[June7]

I have never seen this syntax before: [Excel 8.0; HDR = YES;]

Do you have a reference (web site or something) that suggested it?

What is Ed_Tests$?