Programmatically creating and filling a database

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

Guest

I was wondering if anyone knew a way to have access create
and new database based on information from the current
database. I am wanting to import this created database
into ACCPAC so the information is in a certain format. I
was thinking that there could be some VB code to create
the database and do create table and insert into table
commands to do this.

Any help is greatly appreciated
 
I would think that accpac can import comma delimited files.

It makes no sense to cerate another access database? Why not just import
from the current database (if accpac can do that?).

If accpac can't import form access database..then it is of little help to
have access create a new database?

However, ms-access can export to several common formats like comma
delimited. Check out the help for transfertext.
 
The reason I am wanting to make another access database
is so that the naming conventions that ACCPAC expects
(i.e. AMTDUE for amount due) are all correct. In my
current database the names are not the same as ACCPAC is
expecting. I will consider trying to export to a comma-
delimited file. I think that might be easier. Thanks
for your help.
 
Back
Top