Access and SQL - EDI and Non-MS Data File Imports

[Guest]

Hi,
Where can I find some quick recipes for Importing data
that may not be a MS Office File Format into MS Access
and MS SQL Server databases?

Is this considered EDI?

Thanks.

 

[John Nurick]

You'll need to know the actual format of the data, not just what it may
not be. Access can import data from standard textfiles and spreadsheet
files and some other database files.

There are ODBC drivers available for many other database file formats.

For non-standard text formats, there are specialist tools such as
Monarch; or one write a custom import routine in VBA; or one writes a
script to convert the file into a format Access can parse for itself (in
languages such as Perl, Python, or VBScript.

If you search the archive of this newsgroup at
http://groups.google.com/advanced_group_search?hl=en
you'll find lots of answers to import questions.