Getting data into Access

  • Thread starter Thread starter BrianC
  • Start date Start date
B

BrianC

I have an existing Access DB that contains a number of
tables. I want to get the data from Excel to specific
fields in these existing tables automatically when it is
entered in Excel. How do I do this?

I have an Excel worksheet with three columns of data. The
user enters the data in Excel via a Userform and clicks
FINISH when complete and I execute a number of macros to
generate some data. I then need this data to go into
Access.
 
You must log in or register to reply here.

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Passing data to an event handler 3
Best way to get data from Access 2003 to Excel 2003 6
How to split an excel workbook in code and data 2
Getting information from access table in excel 1
How to copy data from an excel cell into a field in access table 0
help to understand 'querytable' 1
VBA - retrieve data on last create named range from previous inserted named range 0

Back
Top