467,907 Members | 1,401 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,907 developers. It's quick & easy.

Export table from old Access 2002 Database to create a new database

Hi ,

I'm wondering if there is a way for me to export some tables including
data and structure from old database to a new database and then save as
new database name.

I try to create a marco and it create a new table within the same
database.

I would be appreciated if you can help me to create a code for one
button that will export selected tables to a new database and then save
as a new database name file.

Thanks ;-)

Sep 4 '06 #1
  • viewed: 1667
Share:
1 Reply
There's some example code here:
http://allenbrowne.com/unlinked/backup.txt

It creates a new database, and loops through the tables in the current
database, writing them to the new database. If a table is skipped (e.g.
currently locked), it writes that to an error log.

It exports the data into the backup file, whether the tables are linked or
local. It does not create relations, or set all the field properties.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<le************@hotmail.comwrote in message
news:11*********************@b28g2000cwb.googlegro ups.com...
>
I'm wondering if there is a way for me to export some tables including
data and structure from old database to a new database and then save as
new database name.

I try to create a marco and it create a new table within the same
database.

I would be appreciated if you can help me to create a code for one
button that will export selected tables to a new database and then save
as a new database name file.

Thanks ;-)

Sep 5 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

16 posts views Thread by David Lauberts | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.