Importing Table (1 Viewer)

katmando · Jan 17, 2006

I have a linked csv table into access, and have a make table query which runs off this. When i first build and run the query it runs fine, but when i run it again I get the following problem "numeric field overflow" I have checked all the data types, they match fine.....

The thing that i cannot understand is when I rebuild the query from scratch, it works fine for the first couple of times, then stops.

Ron_dK · Jan 18, 2006

You may do a search on 'numeric field overflow' on this forum. There are lot's of suggestions and stuff.
Two things from my own experience though :

1) Instead of importing the csv, make the spreadsheet linked to your table.
2) Ensure that all cell rows, you import from Excel are text fields
and ensure that all Query fields are text as well. Set the field size to 255
in the text data type.

Hope this helps.

katmando · Jan 18, 2006

I'll have a look on the site.
I tried linking direct from excel but had a problem as one of the fields in question had numbers and text in when bouught through to access the numbers would disappear. I tried converting to text but, no luck, hence converting the table to a csv file.

Cheers

clerics · Jan 18, 2006

i'm sorry cuz i have an example which do exactly what you want, but i wrote it by Japannese .. So maybe some make you confuse ! i tried to change a lot to English , if you dont care , let take a look in this program.

clerics · Jan 18, 2006

here is Excel 's test file

katmando · Jan 19, 2006

Thanks For That Clerics, looks like what i need.

Cheers

Importing Table (1 Viewer)

katmando

Registered User.

Ron_dK

Cool bop aficionado

katmando

Registered User.

clerics

Registered User.

Attachments

clerics

Registered User.

Attachments

katmando

Registered User.

Similar threads

Users who are viewing this thread