|
-
Sep 26th, 2000, 08:01 AM
#2
Fanatic Member
What about this:
Use the SQL 'SELECT ... INTO' statement.
It would look something like this:
'SELECT * INTO tbNew FROM [<db1 Path>].tbOld'
Where the above statement would be executed on your target database.
I know the above works on an MS Access database but I've never tried it on any other.
N.B. This copies all fields and data to the new database but you will lose any indexes (inc. primary keys) and possibly field data types.
Unfortunately, I don't think it's possible to append a tabledef object from one tabledefs collection to another!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|