3349 - Numeric Field Overflow

  • Thread starter Thread starter Luke Smith
  • Start date Start date
L

Luke Smith

I am getting the following error when loading a CSV file
into Access 2000.
 
Luke,

Look at your table design (the one you are loading the data to) and see if
you have any numeric fields defined as Integer or Single; change them to
Long Integer and Double respectively, to see if that solves the problem.
Change them one by one to locate the one that causes the problem.

HTH,
Nikos
 
H

I am getting the exact same error, but I am using a create table query that reads all the records from an access table linked to a .csv fil

Any help would be greatly appreciate

Thank
Tshifhiw

----- Nikos Yannacopoulos wrote: ----

Luke

Look at your table design (the one you are loading the data to) and see i
you have any numeric fields defined as Integer or Single; change them t
Long Integer and Double respectively, to see if that solves the problem
Change them one by one to locate the one that causes the problem

HTH
Niko
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import from Linked Spread Sheet In Access 1
Access 2007: external txt data 1
Numeric Field Overflow 8
Error 3349 (Numeric Field Overflow) Only If DB is Split 3
Error 3349 1
Error 3349 while importing data from Excel 0
Linking table gets numeric field overflow 2
Access Query - Error 3349 1

Back
Top