backup up tables

  • Thread starter Thread starter mcnewsxp
  • Start date Start date
M

mcnewsxp

anybody have a nice way of backing up tables automatically.
some linked and some not - all access jet.
tia,
mcnewsxp.
 
found what i needed:


sSQL = "SELECT * INTO [" & DestinationFile & "].[" & tbl.name & "] "
sSQL = sSQL & " FROM [" & txtSource.Value & "\" & "EVdb_New.mdb].[" &
tbl.name & "]"
mconJet.Execute sSQL, , adExecuteNoRecords
 
You must log in or register to reply here.

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

Similar Threads

import from ms access table name unknown 1
select into overwrite table 3
add new record from linked table 9
primary key 3
data merge 0
AUDIT LOG 3
Keep up with connection string 3
make table query corrupts hyperlink field 15

Back
Top