Hi,
I have a Excel sheet that I am importing. I tryed to import the sheet manualy and it said tha tit could not because there are errors (it does nto say what si wrong). So I wrote the following VBA code and it worked except that some cells in one of the fields are blank, but in the sheet the cells are filled. So for example if I look down the field in Access at record 31 and 32 they are blank but in Excell there is data. I made both the the fielsd in Excel and in Access text for a data type. I tryend sending ot to a text file and importing it in, I tryed linking the tables, and I tryed just copying and pasting the cells in; but it still come up blank. So I am not sure what is wrong and or wah to do.
Any ideas woudl really be appreaciated.
Thank you
Here is the code I used to bring it in:
Code:
str2 = "Select [Formated$].* INTO [tblCom07Dump]FROM [Formated$]IN '" & Exls & "'[Excel 8.0; HDR = YES;];"
cn.Execute str2
Like I say this si working but some cells are blank.