How do I create a blank database on 3.5 disk using a macro or VBA

[Guest]

I am trying to write a program that transfers data to a 3.5 inch disk. I
would like to automate the process of opening a new blank database on the 3.5
inch disk.

 

[Guest]

I might take a slightly different approach. You might want to create your
database that does not have any data in it but has all the tables. Then
through code you can first copy the blank or empty database to another file
name, and then copy the desired records to the appropriate tables in that
database.

This will always leave your template database there so you can do the same
process again anytime you need to.

Once the data has been placed into the empty database, you can move or copy
it to a floppy disk or anywhere else you want to.

 

[John Vinson]

On Thu, 12 Jan 2006 14:16:02 -0800, "LT JOSHUA BAILEY" <LT JOSHUA

I am trying to write a program that transfers data to a 3.5 inch disk. I
would like to automate the process of opening a new blank database on the 3.5
inch disk.

Do you actually want a new *database* - a .mdb file container for
multiple tables, forms, procedures, etc.? Or are you trying to
transfer just data, e.g. to be loaded into a table?

If the latter, you may want to consider using the TransferText
procedure to export a table to a comma-separated text file, or
TransferDatabase to export it to a dBase format file. These files can
readily be imported into a table, without the considerable overhead of
transporting a complete .mdb file.

John W. Vinson[MVP]