Importing a text file to a table

[neeko1226]

I'm trying to have a .txt file imported into a linked table on 'Open' of a form. The form is set to open when the database is opened. I have the database opening at a certain time each day. It was working fine, but lately, I've been getting "Run time Error '3349'...Numeric field overflow" errors. The import error table created has one row, with record '0' and the 'ReportDate' field listed. I recently moved the database which holds the table I have linked into my import database, but I have refreshed all of the links sucessfully. The code I have written to import is this:

DoCmd.TransferText acImportDelim, "CD159_DAILY Import Specification", "Tbl_Cd159_Temp", "\\azstor01\bankops$\transfer\mainframe\fdrrpt\In\CD159_DAILY.txt", True

Any Ideas why this is happening?

 

[smedvid]

Just a shot in the dark, check the type of the numeric field in the database table you are attempting to load. You may have hit the limit for an Integer or Single type. Make it a Double to be safe. That may resolve your Overflow Error. Also, review your Import Spec (CD159_DAILY Import Specification) to see if the fields are the proper type(s). htwh,

Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[neeko1226]

I have no numeric fields to import to. All fields are text, except the report date which is date/time. My import specs show the same. Any other ideas?