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!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Import From Excel

Status
Not open for further replies.
cyork

cyork

MIS
Apr 4, 2001
34
CA
Hi,

When trying to import data from an excel spreadsheet I always have to open the excel file in order for it to work.

Any suggestions?

Chris
 
Sort by date Sort by votes
Hi Chris,
What I did was to create a macro and under actions, type TransferSpreadsheet. For the action arguments, select import as the transfer type, and for the file name, use the path and name for where your file is located.


 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

OCM
  • Locked
  • Question
Populate access table from excel
Replies
6
Views
618
OCM
OCM
Moss100
  • Locked
  • Question
Upgrading from Access 2013 - whats the best option
Replies
2
Views
487
Moss100
Moss100
lmcate
  • Locked
  • Question
How to Open ACCESS (MDB) from an HTML Page 1
Replies
2
Views
521
lmcate
lmcate
TheresAlwaysAWay
  • Locked
  • Question
Convert PDF to Excel spreadsheet within Access 2
Replies
10
Views
346
TheresAlwaysAWay
TheresAlwaysAWay
EM1107
  • Locked
  • Question
populate a column with time from other column.
Replies
1
Views
120
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top