open file code in Visual Basic

[smh101]

Hello!

I am an access novice so was wondering in anyone can help me.

Can anyone post the code I need to enter to do the following;

1) Import a file from my local hard drive into a designated table in access

2) Export a number of tables back onto my local hard drive

I would like it so these actions occur when I click on the relevent command box on my form

Any help would be very much appreciated

 

[Moniker]

Look at these commands:

DoCmd.TransferDatabase
DoCmd.TransferText

You didn't specify what sort of files you're importing and what format you are exporting in, so I wasn't sure what direction to point you in.