Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Access import errors
Message
From
03/11/2008 15:33:04
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
XML, XSD
Title:
Access import errors
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01359286
Message ID:
01359286
Views:
116
I am using XML to transfer a VFP database to Access using the commands
CURSORTOXML(lcTable, "c:\myXMLFile.xml", 1, 512, 0, "mySchema.xsd")
oAccess.ImportXML("c:\myxmlfile.xml")
This seems to work almost perfect except that one of the tables produces Access import errors that say "Microsoft JET Database Engine: The field is too small to accept the amount of data you attempted to add." or "Microsoft JET Database Engine: Update or CancelUpdate without AddNew or Edit.". The errors occur on only a few of the records.
The table structure of the Access table appears to match that of the VFP table as far as field widths go. Can someone give me a clue as to what's happening here?
Thanks
Next
Reply
Map
View

Click here to load this message in the networking platform