import excel to Access has a problem with text field
 

Dear all,

I use ADO to connect to excel file to read each row and input to my
access table. the problem is access module alway understand text field,
ex: "a","b",... as null value, how ever access still understand "1n",
"2m"

can someone help me on this


thanks

Bac