W
Wisely
Hi, I have this problem with docmd.TransferSpreadSheet.
In this Excel file has a column combined with numeric (0,1,2....) and
Characters (A, B, C....) when I convert this Excel file into SQL Table Using
Access project it only bring in the 0,1,2,3.... and left the characters as
NULL. Is there a way I can bring everything in even though treat the column
as Varchar?
thanks,
In this Excel file has a column combined with numeric (0,1,2....) and
Characters (A, B, C....) when I convert this Excel file into SQL Table Using
Access project it only bring in the 0,1,2,3.... and left the characters as
NULL. Is there a way I can bring everything in even though treat the column
as Varchar?
thanks,