Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Transfering From Excel to Access

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   Report Post  
Posted to microsoft.public.excel.misc
bpeltzer
 
Posts: n/a
Default Transfering From Excel to Access

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Obtaining a single Access record from Excel input travis Links and Linking in Excel 5 November 23rd 05 09:02 AM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
Excel Spreadsheet from Access. List of names changes as names are Gordy w/Hi Expectations Excel Discussion (Misc queries) 1 October 21st 05 03:30 AM
Access a excel file through FTP without write protection jj Excel Discussion (Misc queries) 0 October 9th 05 05:38 PM
Microsoft Access Report into Excel Spreadsheet zeebyrd Excel Discussion (Misc queries) 1 February 27th 05 12:36 AM


All times are GMT +1. The time now is 08:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"