 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Importing / Linking / May 2005Importing Text File
When I import a text file some of the fields with zeros do not import. The fields are blank. No rhyme or reason why some zero fields import and some don't. I have written an update query to add the zeros but is there way to correct the import problem?? How are you doing the import? What created the text files? If you can answer these two questions, I can show you how to make it work, and possibly explain why some 0 field import and some don't. > When I import a text file some of the fields with zeros do not import. The > fields are blank. No rhyme or reason why some zero fields import and some > don't. I have written an update query to add the zeros but is there way to > correct the import problem?? I download the data from a mainframe, changing the format to a text format. The data is then imported as text delimited into Access. Importing the data worked great using Access v2.0, but never could get the same results using Access 97 or Access2000. I hope this answers your questions. > How are you doing the import? > What created the text files? [quoted text clipped - 6 lines] > > don't. I have written an update query to add the zeros but is there way to > > correct the import problem?? Question is, are you using TransferText, reading it in programmatically, cutting and pasting, or whatever. What I would check it the text file. I don't know about your mainframe text file, but Excel, for example, has a habit you have to check for. If an Excel cell is formatted as General, and nothing has been entered, it import to Access as Null and it exports to text as nothing. for example, you may be expecting: JONES,3,7,99,0,X You Get: JONES,3,7,99,,X Which will import int Access as an empty string into a text field and as Null into a number field. Try setting up an Import Spec for your text file and see if that solves the problem. > I download the data from a mainframe, changing the format to a text format. > The data is then imported as text delimited into Access. [quoted text clipped - 14 lines] > > > don't. I have written an update query to add the zeros but is there way to > > > correct the import problem?? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.