I had a similar case and ending up using ADO, so I could read from any
supported database file/ODBC/ and even CSV files. This means you can
leverage all the installed ODBC drivers etc.
Just had to write a mapper object in betweeen the actual import code/SQL
statement passed to ADO and the columns used in our own database.
I don't think this will work for Outlook (unless there is an ADO/ODBC driver
for the outlook postoffice files?) - will need to use COM objects and it
will require Outlook installed on the machine where it is running.
Myles.
> -----Original Message-----
> From: Jason Coley [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, 16 December 1999 09:22
> To: Multiple recipients of list delphi
> Subject: [DUG]: RE: Importing Data from other formats
>
> Hi,
>
> I'm working on an app that has to have the ability of importing data from
> other data sources, usually contact data, like in ACT and Outlook, now
> imorting from these two isn't difficult if you have the programs on your
> machine. But what if you don't? Also, is there a routine that you can use
> to
> import data from access, dbase etc.
> I guess the best way is for the database importer is to make a field
> mapper
> for importing.
>
> My database that I am using is Access 2000, with the possiblity of
> upsizing
> to SQL Server or MSDE.
>
> Cheers
> Jason
>
> --------------------------------------------------------------------------
> -
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
