Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Access import errors
Message
 
 
To
04/11/2008 17:47:37
General information
Forum:
Visual FoxPro
Category:
XML, XSD
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01359286
Message ID:
01359658
Views:
44
Can you split import of one table into multiple parts?

>OK I solved the first problem by converting the fields from text to memo. (That's not really a solution but it took care of the immediate issue.) The second problem turned out to be invalid ASCII characters in the memo fields. Apparently the data entry folks are sometimes clumsy on the keys. But now I have a third new problem. While importing a very large XML (39 meg) consisting of an integer field and a memo field, Access gets to around 1300 records and then hangs with no error messages at all. My various data checkers don't find any problems with the data. More ideas?
>
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform