Vista - Error when updating Access table from Excel Worksheet

08-09-2009

I've written a VBS script to update an Access table based on an Excel
spreadsheet.

The column that I'm using in Excel to match up in Access is called
"UserDisplayName".

The data in that column contains a comma in it. (For instance: Smith,
John).

When I try to run the script I get an error: Syntax error (comma) in query
expression 'UserDisplayName=Smith, John' code: 80040E14.

I'm not quite sure what to here. If I got into access and do a SQL Query,
I'm able to query something that has a comma in it.

Any suggestions?

Thanks.

08-09-2009

Glenn schrieb:

Quote:

> I've written a VBS script to update an Access table based on an Excel
> spreadsheet.
>
> The column that I'm using in Excel to match up in Access is called
> "UserDisplayName".
>
> The data in that column contains a comma in it. (For instance: Smith,
> John).
>
> When I try to run the script I get an error: Syntax error (comma) in query
> expression 'UserDisplayName=Smith, John' code: 80040E14.
>

I *suppose* your SQL statement misses the single quotes necessary to delimit
string values. If changing your statement/code to

... UserDisplayName='Smith, John' ...

or

... UserDisplayName='" & strNsme & "' ...

don't work, please post the full statement/code to produce it.

Quote:

> I'm not quite sure what to here. If I got into access and do a SQL Query,
> I'm able to query something that has a comma in it.
>
> Any suggestions?
>
> Thanks.
>
>

08-09-2009	#1 (permalink)
Glenn n/a posts	Error when updating Access table from Excel Worksheet I've written a VBS script to update an Access table based on an Excel spreadsheet. The column that I'm using in Excel to match up in Access is called "UserDisplayName". The data in that column contains a comma in it. (For instance: Smith, John). When I try to run the script I get an error: Syntax error (comma) in query expression 'UserDisplayName=Smith, John' code: 80040E14. I'm not quite sure what to here. If I got into access and do a SQL Query, I'm able to query something that has a comma in it. Any suggestions? Thanks.
My System Specs

08-09-2009	#2 (permalink)
ekkehard.horner n/a posts	Re: Error when updating Access table from Excel Worksheet Glenn schrieb: Quote: > I've written a VBS script to update an Access table based on an Excel > spreadsheet. > > The column that I'm using in Excel to match up in Access is called > "UserDisplayName". > > The data in that column contains a comma in it. (For instance: Smith, > John). > > When I try to run the script I get an error: Syntax error (comma) in query > expression 'UserDisplayName=Smith, John' code: 80040E14. > I suppose your SQL statement misses the single quotes necessary to delimit string values. If changing your statement/code to ... UserDisplayName='Smith, John' ... or ... UserDisplayName='" & strNsme & "' ... don't work, please post the full statement/code to produce it. Quote: > I'm not quite sure what to here. If I got into access and do a SQL Query, > I'm able to query something that has a comma in it. > > Any suggestions? > > Thanks. > >
My System Specs

Similar Threads
Thread	Forum
Can not open an existing Excel worksheet	PowerShell
Excel Worksheet Tabs Disappeared in vista 64	Microsoft Office
Finding the last row of and excel worksheet.	VB Script
How to determin a worksheet exist in Excel?	PowerShell
Excel Worksheet	PowerShell