Ask Experts Questions for FREE Help!
Ask    ||    Answer
 
Advanced  
 

Ask QuestionsprogressAnswer QuestionsprogressBuild ReputationprogressBecome an Expert
 
Free Answers in 3 Easy Steps

Register Now		 3 Steps

At Ask Me Help Desk you can ask questions in any topic and have them answered for free by our experts. To ask questions or participate in answering them you must register for a free account. By registering you will be able to:
  • Get free answers from experts in any of our 300+ topics.
  • Accept money for answers that you provide.
  • Communicate privately with other members (PM).
  • See fewer ads.

Home > Computers & Technology > Software > Spreadsheets   »   Access and Excel

Answer this Question Ask about Spreadsheets
 
Thread Tools Search this Thread Display Modes
Question
 
 
#1  
Old Jun 12, 2003, 12:57 PM
dotrain4u
New Member
dotrain4u is offline 		 
Join Date: Mar 2003
Location: NC
Posts: 2
dotrain4u See this member's comment history on his/her Profile page.
Send a message via ICQ to dotrain4u
Access and Excel
Is it possible to import simple information from a spreadsheet in Excel into a pre-existing Access table? If so, how?

Reply With Quote
 
     

Answers
 
 
Old Jun 17, 2003, 05:41 AM   #2  
Computer Expert and Renaissance Man
ScottGem is offline
 
ScottGem's Avatar
 
Join Date: Jan 2003
Location: LI, NY - USA
Posts: 33,646
ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.
Pay to call ScottGem for advice ($.75/min)
Call ScottGem via Skype™
Re: Access and Excel
Yes its very easy. In the Database tab, you select New, Import. Follow the prompts, one of them will ask if you want to append to an existing table.

You might want to link to the sheet first and then use an Append query to make sure the fields match up right.
  Reply With Quote
 
     

Your Answer
Email me when someone replies to my answer
Join Login



Answer this Question Ask about Spreadsheets

« Previous Thread | Next Thread »

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

 
Similar Sponsors


Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page

Similar Threads
windows excel
(1 replies)
excel
(2 replies)
Cant access pop3, Pop3 access not working from my computer
(1 replies)
excel help
(1 replies)
QUestion Excel
(1 replies)

Search this Thread

Advanced Search

Bookmarks

Sponsors



Copyright ©2003 - 2009, Ask Me Help Desk.
All times are GMT -8. The time now is 10:32 AM.