Alpha 4 Version 3 import into Access

E

Elaine C.

I created a new database for the local art center and
imported their old alpha 4 ver. 3 database into the new
one. I can't figure out how to copy info from the old base
table into the new table. There are 2154 records in the old
which I don't want to retype. I have tried to create 2154
blank records in the new database table, open both in
spreadsheet view to copy and paste, but that failed.

Any ideas would be great!

Thank you,
Elaine
 
W

Wayne Morgan

Try linking to the old database table and use an Append Query to import the
information or see if you can just import the old table and adjust it to
your liking.
 
M

Mike Painter

Elaine C. said:
I created a new database for the local art center and
imported their old alpha 4 ver. 3 database into the new
one. I can't figure out how to copy info from the old base
table into the new table. There are 2154 records in the old
which I don't want to retype. I have tried to create 2154
blank records in the new database table, open both in
spreadsheet view to copy and paste, but that failed.
If you have already imported then you can use an append query if you wish to
move the information to a new table.
If not then Alpha 4 will export to a text file and either is or will export
to a dBase file.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top