Transfering From Excel to Access

N

nancyr

I work in a Real Estate Brokerage Firm which relies heavily on Excel
Spreadsheet usage. With spreadsheets becoming maxed out I am seeking
to transfer such spreadsheets into Access. Is this feasible and if so
how can it be accomplished?
 
B

bpeltzer

You can get your spreadsheets into Access. First decide whether to import
(make a one-time copy) or link to the spreadsheet (which would pick up
firther changes make in Excel). From your question, I'll assume you want to
import. From the Tables in Access, right-click in a blank area of the window
and select Import. Be sure to change the 'Files of Type' dropdown to
Microsoft Excel. Then find your file and follow the prompts.
You may run into issues if you've got some text columns that have numeric
values in the first few rows; Access may decide it's importing numbers and
then throw errors on the non-numeric data. If so, you'll have to force those
first few entries to be text. Otherwise, it should be pretty
straight-forward.
HTH. --Bruce
 
Top