VMI wrote:
I have a datatable with emplcodes and I need to extract, from my Access
table, all records that contain an emplcode included in my datatable. In
other words, I need to do a query that accesses a datatable and an access
table. How can this be done? I can't load the Access table into a datatable;
it's too much data.
Thanks.
When you say "database" do you mean a production db like MS SQL db or
Oracle?
Then, as i understand, you have an Access db and an <whatever>SQL db, right?
And if i understood correctly you need to query a <whatever>SQL db to
get a list of emplcode's and to returnall records from Access db which
have those emplcode's.
What i would do is maybe a dirty methhod but it works in my mixed
environment, so it might as well work in yours.
1. Link your <whatever>SQL table to your Access database, as linked table.
2. Create an Access query which will perform what you need.
3. Call this query as a stored proc from C#, after you create a
SQLConnection to the Access db.
It should work fine.
Let me know if you need any addt'l help,
Andrey