Go Back   Talk Microsoft > Microsoft Operating Systems & Software > Microsoft Office Family

Reply
     Is there a way to copy information you have typed up in Microsoft Excel and paste...  
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 11-07-2007, 05:14 PM
Junior Member
 
Join Date: Nov 2007
Posts: 2
Default Is there a way to copy information you have typed up in Microsoft Excel and paste...

...it into Access? I want the info to still be in the different fields that I have it in in Excel.
Reply With Quote
Links
  #2 (permalink)  
Old 11-07-2007, 06:18 PM
jkg jkg is offline
Junior Member
 
Join Date: Nov 2007
Posts: 1
Default

Yes, you can insert info from Excel into Access. Go to Access first and create a new database (name it). On the new database there will be an insert option to import info from an Excel spreadsheet. Depending upon what version of Office you have will determine how you do this. I have Office 2007 that explains the various options for importing the Excel information. For instance, you can import the Excel Spreadsheet and even have a link between your Access database and the Excel spreadsheet. When you make changes to your Excel information, it will be reflected in your Access database, etc. You do not have to link them, though. It is just one option. Hope this little bit of explanation helps. Give it a try--its fun, too.
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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



All times are GMT -4. The time now is 01:21 PM.