Exporting from Excel to Access
Hi Folks
Can anyone please give me an "Idiots Gude" on how to export data from Excell To MS Access?
Many thanks in anticipation
Andrew
Hi Folks
Can anyone please give me an "Idiots Gude" on how to export data from Excell To MS Access?
Many thanks in anticipation
Andrew
mairving posted this at 18:02 — 17th June 2002.
They have: 2,256 posts
Joined: Feb 2001
You have more than one option. You can either import the data or link the data to a spreadsheet that updates Access whenever the spreadsheet is updated. Both of these are accessed on the File/Import menu. This is with Excel 97 & Access 97. I don't know if anything has changed on the newer versions.
Mark Irving
I have a mind like a steel trap; it is rusty and illegal in 47 states
Andrew_Samuel posted this at 21:00 — 18th June 2002.
They have: 82 posts
Joined: Jun 2002
Many thanks mairving, much appreciated
Cheers
Andrew
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.