Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Copy a table from one MDB file to another?

  
   Database Help (Home) -> Visual Basic -> DAO RSS
Next:  Trying to connect to MySQL db with DAO using ODBC  
Author Message
Martin

External


Since: Mar 28, 2008
Posts: 8



(Msg. 1) Posted: Tue Apr 08, 2008 4:11 pm
Post subject: Copy a table from one MDB file to another?
Archived from groups: microsoft>public>vb>database>dao (more info?)
Is there a relatively simple DAO (or SQL) statement that I can execute
in my VB6 program that will copy a table (structure only - no data)
from one MDB file to another MDB file?

 >> Stay informed about: Copy a table from one MDB file to another? 
Back to top
Login to vote
Michael Cole

External


Since: Feb 05, 2007
Posts: 9



(Msg. 2) Posted: Wed Apr 09, 2008 11:01 am
Post subject: Re: Copy a table from one MDB file to another? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Martin wrote:
> Is there a relatively simple DAO (or SQL) statement that I can execute
> in my VB6 program that will copy a table (structure only - no data)
> from one MDB file to another MDB file?

SELECT * INTO [Table] IN [ExternalDatabase] FROM [Source] WHERE 1 = 2

http://office.microsoft.com/en-us/access/HP010322661033.aspx



--
Regards,

Michael Cole

 >> Stay informed about: Copy a table from one MDB file to another? 
Back to top
Login to vote
Martin

External


Since: Mar 28, 2008
Posts: 8



(Msg. 3) Posted: Wed Apr 09, 2008 11:02 am
Post subject: Re: Copy a table from one MDB file to another? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
On Wed, 9 Apr 2008 11:01:59 +1000, "Michael Cole"
wrote:

>Martin wrote:
>> Is there a relatively simple DAO (or SQL) statement that I can execute
>> in my VB6 program that will copy a table (structure only - no data)
>> from one MDB file to another MDB file?
>
>SELECT * INTO [Table] IN [ExternalDatabase] FROM [Source] WHERE 1 = 2
>
>http://office.microsoft.com/en-us/access/HP010322661033.aspx

Thank you. Just what I was looking for.
 >> Stay informed about: Copy a table from one MDB file to another? 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Error conneecting to Access "Cannot Start Your Application.. - I can connect to the database manually, by starting it and entering my login info, but I still get that error. Here is my code: Sub SetUpConnection() On Error GoTo ErrHandler Set adoCN = New Connection adoCN.Provider =..

Connect Data Control to Access 97 secured DB via MDW file .. - Re VB 6.0 & Access 97 I am using the MS Data Control on a form which I need to refresh each time the user enters criteria. The DB is secured via an MDW file. Could someone please provide an example, using DAO, with a solution to connect the Data..

Use DAO to add fields to existing Access table - How do I use DAO.36 code to add 3 fields to existing Access 2000 table Thanks in advance

DAO 3.6 record locking - Hi, Is it possible to programmatically lock a single record in a VB application using DAO 3.6? I would like to lock users' records when they log on to the app. Later I can check if a user's record is locked to see if they are logged in or not. (I....

Fixes for VB4 or DAO 3.0 - I've got VB4 (32-bit) and it seems to use DAO 3.0. Is there a service pack for either of these that I can use? I'm having issues with DAO and > 2GB of RAM on the machine, and don't want to have to move to a newer version of VB if I can help it, just t...
   Database Help (Home) -> Visual Basic -> DAO All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]