creating File->Get External Data->import button, how

[hengsin]

i want to create a button that is similiar to the File->Get External Data->Import. By only clicking on this button, the Import Dialog box will appear to let me choose the file i want. After i choose the file, the Import Object dialog box will appear to let me choose whatever the table, query etc

Thanks

 

[KenReay]

Hi

Try having a look at

DoCmd.CopyObject [destinationdatabase][, newname][, sourceobjecttype, sourceobjectname]

or

DoCmd.TransferDatabase [transfertype], databasetype, databasename[, objecttype], source, destination[, structureonly][, saveloginid]

they may do what you want

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[hengsin]

hi, thanks for your help. But i find another method which is much straight forward:

DoCmd.RunCommand acCmdImport

Your method must be more advanced. I will have a look for what