IMPORTING Excel into Access questiooon?

[Accessme2]

Hi everyone,
I am having some problems and I am not having any luck solving it. here it is: I am using MS access 2002(XP) and some user are using access 2000.
When I run a process that import a xls into an access table and one field(text) containg "**" two asterisk, it imports just find on my PC but everyone else the field ends been blank. I am the only one that can do the import and have the ** on the table everyone else Nothing.
can't figure out what is the deal
this is the code I am using:

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel3, "TEST_TRANSFER", "G:\Temp\Transfer\" & Me.filename_in & ".xls", 1, "Sheet1!A1400"

if anyone have any suggestion please let me know.

thanks

 

[Accessme2]

Okay I just notice it that everyone gets an import error table data convertion on that field.
how can I not get that error same data.??

 

[vbaInet]

Try using acSpreadsheetTypeExcel9

3 is an old version. It all depends on what version of Excel that's being run.

 

[dragofly]

Open up the test_transfer table in design mode and try setting that field's data type to text if it isn't already.