Re: Importing Data into MSACccess

From: wayne <no_at_email.please.com>
Date: 17 Apr 2001 01:41:46 GMT
Message-ID: <9bg70q$cep@dispatch.concentric.net>

> I have used the SQL Loader tool for Oracle, is there an equivalent tool in
> MSAccess?

I'll respond although this is an Oracle NG...

You can make a linked table or write code and open the table with ADO or DAO... If you make a linked table you are OK as long as the source file is always in the same place.

You make a form that upon creation imports from the linked table (or with the aforementioned ADO or DAO code) and then closes itself.

You can then get creative and make it neater, but that is the gist of it. Received on Mon Apr 16 2001 - 20:41:46 CDT