Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel save as csv - force text qualifier on every text field Newbie-Don Excel Discussion (Misc queries) 6 April 2nd 23 08:33 PM
how to import more than 1 text file into the same Excel worksheet. SinnetBS Excel Discussion (Misc queries) 1 June 14th 06 03:14 AM
Excel Text Conversion Problem Michael D Excel Discussion (Misc queries) 0 March 14th 06 12:26 AM
Excel Text Import Wizard [email protected] Excel Discussion (Misc queries) 2 September 12th 05 12:00 AM
Problem pasting numeric data from Access into Excel JP Jones Excel Discussion (Misc queries) 8 July 14th 05 03:26 PM


All times are GMT +1. The time now is 10:53 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"