Importing data from various file formats into Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Back
Top