Syntax for importing data into an Access table from an ODBC data source
Thanks Dan;
The article refers to text file import. I'm trying to import from a
less-known external database called Open Access using a proprierary ODBC
driver called Dharma. I guess the procedure is similar to importing a table
from Oracle or DB2 and is somewhat diferent from importing a text file that
may require column headers.
Thanks
Bill
Quote:
> Hello Bill,
> Click this link and scroll down until you see Microsoft Access Automation.
http://msdn.microsoft.com/library/default.asp?URL=/library/techart/VS...
ev.htm
Quote:
> -Dan Jinks (please reply to the newsgroup)
> Jinks Technoogy Management, Inc. 603-882-8222, http://www.Jinks.com,
> Project management and application development consulting.
> > VB 6.0 - ACCESS 97/2K
> > I need help regarding the code to import data into an access table from
an
> > ODBC connection. Assuming Access is installed in the PC that is running
the
> > VB application.
> > Thanks
> > Bill
