doulos
Jan 27 2004, 11:11 PM
How to export data to a new mdb file?
thanks
strive4peace
Jan 27 2004, 11:12 PM
Make a blank database
File, Get External Data, Import
doulos
Jan 27 2004, 11:59 PM
Sorry, my Q should be like this: how to use access code to export a group of filtered data to a new file which is not exist yet?
Thanks
strive4peace
Jan 28 2004, 12:30 AM
mNewName = "c:\test.mdb"
If Dir(mNewName ) <> "" Then Kill mNewName
DBEngine.CreateDatabase mNewName , dbLangGeneral
Then you can use
DoCmd.TransferDatabase [transfertype], databasetype, databasename[, objecttype], source, destination[, structureonly][, saveloginid]