Pasting from excel to access

  • Thread starter Thread starter jay
  • Start date Start date
J

jay

! have 3 columns I want to paste into an access table.
A1:C3 and rows 1 to 100.
Is it possible to run excel and have a macro to open
an access table and then select the area and paste?
 
Jay

Not quite sure of your range reference A1:C3 and then some rows? But is you
go into access and select File>Get external data>link tables, you can link
the table into access, you can then build a query in access to get the data
in

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Moving a bunch of data 1
VBA - retrieve data on last create named range from previous inserted named range 0
Copy & Paste 1
How to export table from outlook into ms access table? 0
X,Y,Z values to be extracted and posted respectively in excel 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Excel VBA Macro to do this? 19
Scatter plot / Data from matrices? 1

Back
Top