errors while importing txt file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i use the following code for import
DoCmd.TransferText acImportDelim, , "TempTable", Me.txtFileName, False

Me.txtFileName=New Raw Data.txt
TempTable = all fields(F1-F44) are type double

after import i see that 2 tables are created with the following data...
VALUE field is not part of the table... i traced the value of that
row,column in the txt file...

the corresponding cells in the temptable are 'null' - the value is not
imported
i have a total of about 5000 records with 44 fields... only these three are
null

New Raw Data_ImportErrors
Error Field Row VALUE
Type Conversion Failure F43 106 7926580275
Type Conversion Failure F28 726 2543224500
Type Conversion Failure F34 1924 6025667800

Name AutoCorrect Save Failures
Object Name Object Type Failure Reason Time
TempTable Table Could not save the object 5/17/2007 4:30:40 PM

why am i getting these errors? how do i fix them? also in the temptable.. i
have one blank row.. all fields are null... why does it insert this null
record... how do i restrict it?
 
Hi,
perhaps imported value exceeds field limit? what you can do -import all
fields as text into one more temp table (create import specification for
this) and then run append query to insert all rows you need to TempTable,
converted to proper type

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com
 
Back
Top