By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,669 Members | 2,546 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,669 IT Pros & Developers. It's quick & easy.

Access 97 and importing csv file...type conversion failure

P: n/a
OK this is a weird one.

I've got an import routine going whereby name and address data is pulled
into a table from a csv file.

I'm having strange results when importing postcode/zip data into a text
field. I'm also using an import specification that specifies the post/zip
code field is text.

If the contents of that column are all alphanumeric UK postcodes e.g. LL55
2PW then that field imports fine. If, however, there are numeric only US
zipcodes and the number of zipcodes is more than the UK postcodes, for some
reason Access only imports the US zipcodes and gives me a "type conversion
failure" for the UK Postcodes. I find this strange being that the field
they're importing into is text and the specification says the field is text.
I would have thought the problem would be the other way round!

I've done a bit of research into this and came across a posting in this
group that mentions Access scanning the column to determine the format of
the field. That might make sense if it's finding more numeric data than
alphanumeric but how can it override the import spec? And more importantly,
how do I workaround this?

Thanks

Alan
Oct 6 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
OK this is a weird one.
>

Sorry, just worked out the code I was using wasn't using the import
specification...doh! It now works OK.

Alan
Oct 6 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.