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..
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...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
Thank you,
Thai
