Importing data from various file formats into Access

[Steven]

I have to connect data that currently exists in various file formats - flat
files, Excel, Access, SQL Server, and Clarify.

Can I use Access to import from all of these formats? I know that I can
import from Excel, flat files, and Access. I believe that I can import from
SQL Server using the OBDC option. Can I use OBDC for a Clarify database as
well?

Is there any way that I can automate the process so that the import takes
place at night after the source databases have been updated? All source
databases will keep their names and locations constant.

TIA.

 

[Douglas J. Steele]

If you have an ODBC driver for Clarify, then you should be able to import
it. Otherwise, is there a possibility to export it from Clarify in a format
that Access will accept?

Take a look at the TransferDatabase and TransferSpreadsheet methods. You'll
need to write code using those methods to automate the import.