Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Trying to get an excel template to feed data to access database
- Thread starter bcblair
- Start date
So do you want to get data from Excel into Access?<br>
you can just Link to your Excel Spreadsheet.<br>
In Access Click the Tables TAB<br>
Right click in the White Space and then click "Link Tables"<br>
Down at the botton in "Files of Type" find "Micosoft Excel (*.xls)"<br>
Find your Sheet and then follow the prompts.<br>
<br>
Now you have a Linked Excel spreadsheet to do what ever you wnat with.<br>
<p> DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br>
you can just Link to your Excel Spreadsheet.<br>
In Access Click the Tables TAB<br>
Right click in the White Space and then click "Link Tables"<br>
Down at the botton in "Files of Type" find "Micosoft Excel (*.xls)"<br>
Find your Sheet and then follow the prompts.<br>
<br>
Now you have a Linked Excel spreadsheet to do what ever you wnat with.<br>
<p> DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br>
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question