first recording not importing

slimjen1

Registered User.
Local time
Today, 17:48
Joined
Jun 13, 2006
Messages
562
I am using access 2003. I've setup an import specification for a text file to import into a table. It's importing but leaving off the first record. When I setup the import specification, I did so as fixed width because the fields were not defining correct when I used delimited. Could it be that it's thinking that the first record include the field names? If so, how do I rectify this?
thanks
 
When you set up the import spec, did you make sure the First Row As Headings checkbox was unchecked?
 
using fixed width doesn't give me that option. Using delimited does but does not allow me to define my fields. I have six fields but it only sees two and doesn't allow me to change it.
 
I have 2002 and I can define it in both?
 

Attachments

  • ScreenShot109.jpg
    ScreenShot109.jpg
    34.5 KB · Views: 135
  • ScreenShot110.jpg
    ScreenShot110.jpg
    45.4 KB · Views: 128

Users who are viewing this thread

Back
Top Bottom