Select from a access table

[frank]

I am looking for a way to select some data from a Access database into my
SQL database.

In Enterprise manager, I want to do someting like:

SELECT InvoiceNo, CID
FROM c:\MyAccessData base.mdb\CIDTab le
WHERE Imported=0

[Plamen Ratchev]

Re: Select from a access table

Create a linked server using the OLE DB Provider for Jet and then you can
query all Access tables:

http://msdn.microsoft.com/en-us/library/aa172697(SQL.80).aspx

HTH,

Plamen Ratchev

http://www.SQLStudio.com

[Kevin Zhong]

Re: Select from a access table

On Jun 13, 6:35 am, "frank" <frank...@onlin e.nowrote:

I am looking for a way to select some data from a Access database into my
SQL database.
>
In Enterprise manager, I want to do someting like:
>
SELECT InvoiceNo, CID
FROM c:\MyAccessData base.mdb\CIDTab le
WHERE Imported=0

you must create a connection instance at first.

code following:
System.Data.Ole Db.OleDbConnect ion conn=new
System.Data.Ole Db.OleDbConnect ion("Provider=x xxx;datasource= c:
\MyAccessDataba se.mdb;");
System.Data.Ole Db.OleDbCommand cmd=new
System.Data.Ole Db.OleDbCommand ("SELECT InvoiceNo, CID FROM
CIDTable",conn) ;

System.Data.Ole Db.OleDbDataAda pter ada=new
System.Data.Ole Db.OleDbDataAda pter(cmd);
DataTable dt=new DataTable();
ada.Fill(dt);


ok.
the data in DataTable object.