Frenchy646
11-10-2010, 02:17 AM
Hello,
I have a program in VBA which manually imports information from an Excel file into an Access table (both 2003, and I am running on XP ), as the already present import option in Access does not suit my requirements.
It all works fine, until it gets to a certain number of rows on the Excel file.
On this Excel file, on row 1075, I get an error :
Syntax error : Missing Operator in query :
"SELECT * FROM Customer_Identifiers WHERE (((Customer_Identifiers.Field1) = 'EV') AND
((Customer_Identifiers.Field2)='AB10000525') AND ((Customer_Identifiers.Field3)='AB6014') AND ((Customer_Identifiers.Field4)='This is a description') AND ((Customer_Identifiers.Field5='AB10000525) AND ((Customer_Identifiers.Field6='F0631A' AND"
And the message box does not indicate the rest of the query.
When I choose to debug, I look at the string in which the query is stored, and all that is there is :
"SELECT * FROM Customer_Identifiers WHERE (((Customer_Identifiers.Field1) = 'EV') AND
((Customer_Identifiers.Field2)='AB10000525') AND ((Customer_Identifiers.Field3)='AB6014') AND ((Customer_Identifiers.Field4)='This is a description') AND
((Cu
Why is this happening ? Could it be a memory problem ?
Any ideas are welcome.
I have a program in VBA which manually imports information from an Excel file into an Access table (both 2003, and I am running on XP ), as the already present import option in Access does not suit my requirements.
It all works fine, until it gets to a certain number of rows on the Excel file.
On this Excel file, on row 1075, I get an error :
Syntax error : Missing Operator in query :
"SELECT * FROM Customer_Identifiers WHERE (((Customer_Identifiers.Field1) = 'EV') AND
((Customer_Identifiers.Field2)='AB10000525') AND ((Customer_Identifiers.Field3)='AB6014') AND ((Customer_Identifiers.Field4)='This is a description') AND ((Customer_Identifiers.Field5='AB10000525) AND ((Customer_Identifiers.Field6='F0631A' AND"
And the message box does not indicate the rest of the query.
When I choose to debug, I look at the string in which the query is stored, and all that is there is :
"SELECT * FROM Customer_Identifiers WHERE (((Customer_Identifiers.Field1) = 'EV') AND
((Customer_Identifiers.Field2)='AB10000525') AND ((Customer_Identifiers.Field3)='AB6014') AND ((Customer_Identifiers.Field4)='This is a description') AND
((Cu
Why is this happening ? Could it be a memory problem ?
Any ideas are welcome.