Excel To Access

[Guest]

I am Currently using a multi sheet excel spreadsheet and want to export
information from selected cells on individual sheets into Access creating a
new record with each one. Any solutions ??

 

[Joseph Meehan]

I am Currently using a multi sheet excel spreadsheet and want to
export information from selected cells on individual sheets into
Access creating a new record with each one. Any solutions ??

Many possible solutions.

Many possible questions, like how are you going to identify the records
you want and don't want to bring into Access?

 

[Rob Parker]

You don't explain anything about how your "selected cells" correspond to a
record (a single entry in a table) in Access. As a first attempt, I'd
suggest consolidating all the Excel cells you wish to export into a single
sheet, and then use the TransferSpreadsheet method to import them into a
table (either new or existing - in the latter case the fields must match) in
Access.

If you really want to do an import of randomly-selected cells from multiple
sheets, it's will require lots of custom code in either the Excel workbook
(as code to export to an Access database), or in an Access database (to
import from the Excel workbook). Either way, it will require a detailed
understanding of the Object Models of both Access and Excel.

The first suggestion seems much simpler to me. If you require more details,
please ask further.

HTH,

Rob