Add a Table to the Database via "OnClick"

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Addammer@gmail.com - 21 Mar 2007 17:14 GMT

Is there a way to add a table to the database using a button and the
On Click event?

In the end, I would like to allow my customer to be able to browse to
a .csv file on the desktop, import it into Access. Finally, on a form,
be able click check boxes on which columns they would like displayed
on a Report. Then run a report.

I'm trying to tackle one thing at a time.

Thanks,
Adam

Reply to this Message

Pat Hartman (MVP) - 21 Mar 2007 17:59 GMT

You can use the TransferSpreadsheet to import or link to a spreadsheet. The
problem with what you are trying to do is that you are trying to replicate
functionality that Access already contains which IMHO is a waste of time and
money. Rather than having users import new tables into their production
database and then use an interface you build to create reports on the fly, I
would teach the users how to use the actual Access features and give them
their own database in which to work so that the shared database isn't
cluttered by this importing activity. They will have much more flexibility
than you can possibly give them without replicating the report builder.
Teach them how to use the wizards to get started.

> Is there a way to add a table to the database using a button and the
> On Click event?
[quoted text clipped - 8 lines]
> Thanks,
> Adam

Reply to this Message