Hello I am getting something very strange when I try to import an excel sheet to access through code using select into or insert into..

Code:
dim cn as new adodb.connection

cn.open "Driver=Microsoft Excel Driver (*.xls);DriverId=790;DBQ=C:\test.xls"

cn.execute "SELECT * INTO [;database=C:\test.mdb].[Table1] FROM [Sheet1$]"

cn.close
set cn =nothing
if a field in the spreadsheet has a ., -, or non text or numeric character, it imports it as NULL.. is there ANY way around this? I have been trying anything I can think of. I sthere a better way to import through code? PLEASE help, I am completely out of ideas...

Thank you,
Thai