Also, while processing a different DBC it gives an error on one of the tables that says Access is having a problem processing the schema. I tried to post the schema here but it seems the code tags don't work with it. It is a simple table with only an integer field and a memo field. I can't figure what this one might be either.


>Check for values in the numeric fields that are bigger than filed definition specifies. For example
>

>CREATE CURSOR test (num N(3,1))
>INSERT INTO Test VALUES(999)
>BROWSE
>

>As you can see 3 digits number is stored in a field that suppose to allow only 1 digit before decimal point.
>
>>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?