C
Cindy PR
My company uses an excel file to compile a lot of
information into various fields. The excel file has
different worksheets to store information. Some of this
information needs to be stored in an Access Database.
I need to come up with a way to simply click a button
(maybe through the use of a Macro) so that only specific
fiels from specific worksheets is uploaded into specified
fields in one of my Access tables.
I figured out how to import data from an excel file with
the use of a Macro, but the file had only one worksheet.
I need a more structured method to be able to pick and
choose specific worksheets and fields, and store them into
specified fields in the table.
Any suggestions?
information into various fields. The excel file has
different worksheets to store information. Some of this
information needs to be stored in an Access Database.
I need to come up with a way to simply click a button
(maybe through the use of a Macro) so that only specific
fiels from specific worksheets is uploaded into specified
fields in one of my Access tables.
I figured out how to import data from an excel file with
the use of a Macro, but the file had only one worksheet.
I need a more structured method to be able to pick and
choose specific worksheets and fields, and store them into
specified fields in the table.
Any suggestions?