Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 " wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Obtaining a single Access record from Excel input | Links and Linking in Excel | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Excel Spreadsheet from Access. List of names changes as names are | Excel Discussion (Misc queries) | |||
Access a excel file through FTP without write protection | Excel Discussion (Misc queries) | |||
Microsoft Access Report into Excel Spreadsheet | Excel Discussion (Misc queries) |