View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ABCBAC ABCBAC is offline
external usenet poster
 
Posts: 2
Default 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