Import Individual Rows of Excel Data

[Jill]

Is it possible to import a row of Excel data into an existing Access
database? The Excel spreadsheet is being updated on a regular basis, and I
would like to take the updated information and add it to the current Access
database. Is there VBA code to do this?

 

[Jeff Boyce]

Jill

So you want two copies of the same data, one copy in Excel and another in
Access?

If you/your users make a change to one of those copies, how do you determine
which one is the correct one?

An alternative might be to link to the Excel data, rather than make copies
of it...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[Jill]

Ultimately, what I am looking to do is to take data from multiple Excel files
and import it into one Access database. The data that I am taking from Excel
would actually be from multiple Excel files. For example, I have one Excel
file with build data for every product we produce. I would then like to take
the data from each Excel file and put it into an Access database. Does this
help?

 

[Jeff Boyce]

Jill

Whether you're taking data from one Excel spreadsheet or many, the issue
remains.

If you maintain BOTH the Access and the Excel data stores, which one is
correct? What happens when a value is changed in one source but not the
other?

And the notion of linking to each/all of the Excel spreadsheets works for
one or for many.

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[Ken Snell]

When you're ready to look at importing from the EXCEL files, this article
may give you some starting assistance:

Import Data from Specific Worksheets in All EXCEL Files in a single Folder
via TransferSpreadsheet (VBA)
http://www.accessmvp.com/KDSnell/EXCEL_Import.htm#ImpFldWrkFiles

I have other examples on that page too.