import data into new db without access

[verant]

Is there any way to write a script that imports data from one Access database to another to be executed on a machine that does not have the Access software? The general structure of the two databases is the same. The new database just has additional tables and/or rows.
Thanks for any guidance!

 

[FLabrecque]

Not to my knowledge. What could be possible:

1. Requires Access to be installed: have a macro that imports the data.
2. Use Pc #1, which has access, and export the data on the Access file on PC #2 (requires a network of some sort).
3. Use some kind of programming software (vb, c++, java, etc.).

 

[mresann]

The best method would be to export the data in a comma separated value delineated format to a text file, then let the other database import the data into its own language. If you have less than 10 tables then exporting by hand will only take a few minutes.

First, open the database to the DB window. Next, select the first table. Click File, then Export. In the dialog box, on the File Type, select "Text File". Do not click the "Format" box to the right of the filename. The filename should default of the name of the table with the text extension, i.e., "tblName.txt". Note which folder the text file will be created. If desired, create a folder to house the text files you will be creating. Next, click "OK".

A new dialog box will open up. In order, click "Delimited", "Next", "Comma", "Next", "Finish". When you open up the text file, you will notice the data will be delineated by commas, which virtualy every other database application in the world recognizes and will be able to import to it's own format. Repeat for every table in the database. Once this is done, follow the Import Data procedure of the database on the remote server.

 

[Pat Hartman]

Separate in your minds Access the application development tool that builds and runs forms/reports/queries/macros/procedures and Access the database server that manages table maintenance. Jet manages Access tables and as long as Jet is installed, you don't need Access to get data from tables. You can use ADO from any language that supports it such as VB or C++ or Java or ASP and anything you can do with ADO, you can do without Access installed.

So, yes verant, you can write procedures in any other language that supports ADO. No, you cannot use the Access GUI or run an "Access" application without Access installed.