SQL
 

Hi

I am not a developer but do use VB etc.

My company has an ERP system with configurator models that configure products.

I am trying to pull data into the ERP from an excel file with an ODBC
connection.

I have set up the connection data source with Microsoft Excel Driver

When I run this query:

SELECT code, descrption, qty
FROM Sheet1

I get an error message saying that the object "Sheet1" cannot be found. I
dont get any connection error msgs.

Can anyone point me in the right direction? Do I have to adjust a setting
anywhere?

SQL
 

check this site out...

http://www.erlandsendata.no/english/...php?t=envbadac

--
Mark Ivey
"scottfoxall" wrote in message ...
Hi

I am not a developer but do use VB etc.

My company has an ERP system with configurator models that configure products.

I am trying to pull data into the ERP from an excel file with an ODBC
connection.

I have set up the connection data source with Microsoft Excel Driver

When I run this query:

SELECT code, descrption, qty
FROM Sheet1

I get an error message saying that the object "Sheet1" cannot be found. I
dont get any connection error msgs.

Can anyone point me in the right direction? Do I have to adjust a setting
anywhere?

SQL
 

Thankyou Mark

The site was most helpful

"Mark Ivey" wrote:

check this site out...

http://www.erlandsendata.no/english/...php?t=envbadac

--
Mark Ivey
"scottfoxall" wrote in message ...
Hi

I am not a developer but do use VB etc.

My company has an ERP system with configurator models that configure products.

I am trying to pull data into the ERP from an excel file with an ODBC
connection.

I have set up the connection data source with Microsoft Excel Driver

When I run this query:

SELECT code, descrption, qty
FROM Sheet1

I get an error message saying that the object "Sheet1" cannot be found. I
dont get any connection error msgs.

Can anyone point me in the right direction? Do I have to adjust a setting
anywhere?