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!

Excel and Access

Status
Not open for further replies.
sopmac

sopmac

MIS
Jun 28, 2001
6
US
Does anyone know of a macro that will allow me to send an excel 97 sheet to an access 97 database? Any help will be appreciated.
 
Sort by date Sort by votes


This could be done a number of different ways.

EG.
Link Excel workbook as a table in Access
Save Excel workbook and import into Access (a process that could be automated from excel/access if required)

There are many more ways. If you could give more details - a best fit solution may be given.

Stew
 
Upvote 0 Downvote
thanks for the reply, stew. well, i'd like to automate the process so that if a button is clicked the excel data will be shipped to the access database. i'm not too familiar with vb and macros, but am sure that it is the way to accomplish the task.

thanks again in advance,
Ivan
 
Upvote 0 Downvote


Hi Ivan

Have you looked into my previous suggestions? If so, why are they inadequate?


Stew


 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Bijugate
  • Locked
  • Question
Excel update question
Replies
0
Views
299
Bijugate
Bijugate
Pirouette
  • Locked
  • Question
Excel workbook
Replies
1
Views
294
combo
combo
shytott
  • Locked
  • Question
Excel - Toggle Button Code 1
Replies
10
Views
869
shytott
shytott
renigar
  • Locked
  • Question
Excel Power Query refresh error
Replies
3
Views
666
SoftwareRT
SoftwareRT
arvarr
  • Locked
  • Question
Excel Formula Help 1
Replies
7
Views
305
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top