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
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...- sbn
- Post #5
- Forum: Microsoft: Access Other topics
-
Access 97 error importing comma-delim. file that Access 2.0 imports ok
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...- sbn
- Post #3
- Forum: Microsoft: Access Other topics
-
Access 97 error importing comma-delim. file that Access 2.0 imports ok
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- sbn
- Thread
- Replies: 4
- Forum: Microsoft: Access Other topics
