Importing spreadsheet to a table from a button

7

72185

We recieve information weekly and sometimes more frequent then that.
I have a access database set up with a table, queries and reports.
What I would like to do is instead of having to manually go in and
import the table to make it more user friendly to the folks that don't
know how to use access that well. I figure this will have to be done
through code to call the worksheets, but I would like to create a
button on a form that when selected it will automatically import the
spreadsheet directly to the table. If it has to call the wizard that
still would not be as bad and navigating through everything but if
anyone knows of how to do this task simply and efficiently please let
me know. Thanks.

-WS
 
D

Dirk Goldgar

In
72185 said:
We recieve information weekly and sometimes more frequent then that.
I have a access database set up with a table, queries and reports.
What I would like to do is instead of having to manually go in and
import the table to make it more user friendly to the folks that don't
know how to use access that well. I figure this will have to be done
through code to call the worksheets, but I would like to create a
button on a form that when selected it will automatically import the
spreadsheet directly to the table. If it has to call the wizard that
still would not be as bad and navigating through everything but if
anyone knows of how to do this task simply and efficiently please let
me know. Thanks.
Click to expand...

It's certainly doable, and not very difficult, but we need more
information to give specific advice:

Do you need to import more than one worksheet at once, from a single
workbook file?

Do you need to import more than one workbook file at a time?

Are the files to be imported always in the same folder?

Do the files to be imported always have the same name(s)?

Do the worksheets to be imported always have the same name(s)?

Do the worksheets to be imported always have the same format and column
names?

Do you add the imported data to the existing data in the table, or do
you replace the data in the table?
 
7

72185

In


It's certainly doable, and not very difficult, but we need more
information to give specific advice:

Do you need to import more than one worksheet at once, from a single
workbook file?

Do you need to import more than one workbook file at a time?

Are the files to be imported always in the same folder?

Do the files to be imported always have the same name(s)?

Do the worksheets to be imported always have the same name(s)?

Do the worksheets to be imported always have the same format and column
names?

Do you add the imported data to the existing data in the table, or do
you replace the data in the table?
Click to expand...

Thank you for trying to help but I think I figured it out. It might
not be the BEST way but it works for what I need now but thank you for
trying

-WS
 
Top