Prev: MSDE upgraded to SP4 but showing SP2
Next: Connection pooling issue with pass through queries
From: frank on 12 Jun 2008 18:35
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:\MyAccessDatabase.mdb\CIDTable
WHERE Imported=0


From: Plamen Ratchev on 12 Jun 2008 22:37
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

From: Kevin Zhong on 14 Jun 2008 23:48
On Jun 13, 6:35 am, "frank" <frank...(a)online.no> wrote:
> 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:\MyAccessDatabase.mdb\CIDTable
> WHERE Imported=0

you must create a connection instance at first.

code following:
System.Data.OleDb.OleDbConnection conn=new
System.Data.OleDb.OleDbConnection("Provider=xxxx;datasource=c:
\MyAccessDatabase.mdb;");
System.Data.OleDb.OleDbCommand cmd=new
System.Data.OleDb.OleDbCommand("SELECT InvoiceNo, CID FROM
CIDTable",conn);

System.Data.OleDb.OleDbDataAdapter ada=new
System.Data.OleDb.OleDbDataAdapter(cmd);
DataTable dt=new DataTable();
ada.Fill(dt);


ok.
the data in DataTable object.
 | 
Pages: 1
Prev: MSDE upgraded to SP4 but showing SP2
Next: Connection pooling issue with pass through queries