Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 826
  • Last Modified:

SQL Statements for excel sheets via ADO

Hi all,
I have a problem in accessing the excel sheets via ADO using SQL command. If I access the excel sheets using a single word field (e.g. PartNo), I can retrieve the data without problem but if I try to retrieve data using a two word field (e.g. First Name), I will have an exception. Does anyone have any idea how to solve this problem.

select * from pract$ where PartNo is 'A1234'   // this can work

select * from pract$ where First Name is 'John'   // this cannot work

A billion thanks
Rice Cake.

0
antioch_75
Asked:
antioch_75
1 Solution
 
kretzschmarCommented:
usual you do doublequote the field

select * from pract$ where "First Name" is 'John'  

but it could only be that you must use brackets

select * from pract$ where [First Name] is 'John'  

must test mySelf First

meikl ;-)
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now