I wonder if you can help with my Access query.
I have a spreadsheet that I am importing into Access using the following line:
DoCmd.TransferSpreadsheet acImport, 8, "raw_data", "c:\file.xls", False, ""
This works fine on my PC and all fields are of type text. But when it is run on someone else's PC (both using Excel and Access 2000) I get the types of the fields being the type of data in the first row of the spreadsheet, which isn't what I want and is not representative of the type of data in that column.
Do you know why there is a difference? and do you know how I can import this file making sure all fields are of type text?
Any ideas would be much appreciated.
I have a spreadsheet that I am importing into Access using the following line:
DoCmd.TransferSpreadsheet acImport, 8, "raw_data", "c:\file.xls", False, ""
This works fine on my PC and all fields are of type text. But when it is run on someone else's PC (both using Excel and Access 2000) I get the types of the fields being the type of data in the first row of the spreadsheet, which isn't what I want and is not representative of the type of data in that column.
Do you know why there is a difference? and do you know how I can import this file making sure all fields are of type text?
Any ideas would be much appreciated.
)