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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.