Link to home
Start Free TrialLog in
Avatar of squidlings
squidlings

asked on

Help with importing data, VB code to delete old table and replace with the new import.

Hi Experts,

Today I would like to know how I could write a little bit of code so when you push a button in MS Access on a form, it will...

1) Delete the a table called "SSL"
2) Import an excel file from, lets say in the root (C:\>SSL.xls )  into a table to replace the 1 we've just deleted called "SSL"
3) I'd like the database to keep all it's relationships.

I need to do this because the information is constantly being updated.  I'd like to use the link to *.xls but se MS Access isn't so great at guessing mulitple assigned fields, import is the easiest method I think.

Thanks Everybody
ASKER CERTIFIED SOLUTION
Avatar of peter57r
peter57r
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial