Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access 97 error importing comma-delim. file that Access 2.0 imports ok

Status
Not open for further replies.

sbn

Programmer
Feb 15, 2000
3
US
I have a comma-delimited file, where text fields are in double quotes.<br>

<br>

Importing directly into Access 97 doesn't work: Error message
 
I don't know if your message was truncated or not, but I couldn't see the exact error message. Anyway, It could be that the default separator character is different in 97 than in 2.0, or in 2.0 you had set up a spec that imports fine, but that spec may be much different than the defaults for 97. Anyway, I'd just go throught the Import wizard step-by-step and make sure that the separator (usually a comma) is matching you're data, the text qualifier, and any other relavent import properties.<br>
--Jim
 
Here's the complete question. Thanks.<br>
<br>
- I have a comma-delimited file, text fields in double quotes.<br>
<br>
- Import directly into Access 97 doesn't work: Error message "External table isn't in the expected format." (I did make sure that the field delimiter & string identifier are correct.)<br>
<br>
- Import directly into Access 2.0 does work - no error messages,data looks good.<br>
<br>
- Import directly into Excel 97 also works - no error messages, data looks good - & by saving in Excel as a workbook & importing the workbook into Access 97 I can get the data there.<br>
<br>
- Is there a bug in Access 97 concerning delimited-file import, or is it just enough pickier than Access 2.0 & Excel that it won't accept this file, or is there another step I need to be doing, or is there a patch?<br>
<br>
- Problem occurs on at least 2 different pc's. (I tested elsewhere because I thought there might be a problem w/the installation of Access on the first one.)
 
Sbn,<br>
If it were Access 95, I would expect this type of problem, A95 was such a horrifying disaster, expecially (at least in my experience) with import/export specs. But Access 97 has been smooth in that regard for me, but it may just be, as you suggest, that it's a little pickier--maybe one record has 20 fields instead of 21, or, more likely, a date field has a bad date. All I can suggest is going through 'the long way' and setting each fields properties in the Import Wizard, and manually setting all fields to Text, then if that works, start by changing a date field to date, one by one, etc. <br>
--Jim
 
Hmmm... I did go to Advanced & make sure all of the fields were trying to import as Text. The one possible clue I found today in a MS newsgroup (microsoft.public.access.externaldata) was that there seem to be quirks relating to importing currency fields.<br>
<br>
And I do have one currency field in the file I'm trying to work with, though it, like all the other data, is inside double-quotes, which I've specified as the text qualifier.<br>
<br>
Does this spark any further ideas, or thoughts of a work-around (I hope!)?<br>
<br>
Thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top