Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why do I get invalid data error message on import into t
Message
From
21/07/1998 16:23:42
 
 
To
20/07/1998 21:25:06
Rick Clarke
Fotobae Pty. Ltd.
Adelaide, Australia
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00119529
Message ID:
00119863
Views:
38
>>>I have a VFP5 Table that I have imported data into no problems once.
>>>I used copy stru to temp.dbf to make a copy, I then attempted the same import from the same .SDF file into the new table. This went well. I then attempted to use the APPEND FROM command e.g. from temp.dbf into my original table called ltolast.dbf. I get an invalid data error but I have checked the 2 tables and they are identical. If I use append blank and replace fields I also get the error. But I can open and brow the 2 tables on screen and manualy copy fields from table to table with no error. What could possibly be wrong.
>>>COPY STRU TO should ensure likeness and the fact I set the temp table to be exactly the same as the original including named fields and index's sends me around the twist! Can anyone HELP!!!!
>>>TIA
>>>Rick Clarke

Rick,

Try this: Append blank and then replace one field at a time until you find which field contains the offending data. As a suggestion, try the last field in the table first.

Good luck.


Ken Cluff
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform