M
Malcolm Cook
Dear MS Support,
I get the error
Run-time error '31550':
Not all of your data was successfully imported. Error descriptions with
associated row numbers of bad records can be found in the Microsoft
Office Access table 'ImportErrors'.
When I run Application.ImportXML in an ADP
Application.ImportXML "C:\path\to\myfile.xml", acAppendData
When I look at the ImportErrors table, I see entries like:
XML Text
Error Message
Result
Timestamp
my_Table
Table was not imported
4/10/2006 2:21:11 PM
but when I look at my_Table I see that all the data is in myfile.xml did import correctly!
I'm using Access 2003 against SQL Server 2002 SP3
One thing that strikes me as very odd is that wne I trace the activity using SQL Profiler, I see 'create table' statements, even though I provide acAppendData
Ideas? Suggestions? Anyone?
I get the error
Run-time error '31550':
Not all of your data was successfully imported. Error descriptions with
associated row numbers of bad records can be found in the Microsoft
Office Access table 'ImportErrors'.
When I run Application.ImportXML in an ADP
Application.ImportXML "C:\path\to\myfile.xml", acAppendData
When I look at the ImportErrors table, I see entries like:
XML Text
Error Message
Result
Timestamp
my_Table
Table was not imported
4/10/2006 2:21:11 PM
but when I look at my_Table I see that all the data is in myfile.xml did import correctly!
I'm using Access 2003 against SQL Server 2002 SP3
One thing that strikes me as very odd is that wne I trace the activity using SQL Profiler, I see 'create table' statements, even though I provide acAppendData
Ideas? Suggestions? Anyone?