T
Tony Williams
Once a day we recive an Excel spreadsheet that contains data for certain (but
not all) the fields in one of the tables of a database. I know that it is
possible to import these using the wizard but I wondered whether there was
any way to automate the process. For example, ideally I would like a command
button that I clicked which opened up the Windows Explorer Browse window,
allowed me to browse for the file and, when found, the data would be
automatically added to the table when, say, the Explorer window is closed.
I'm assuming that I would have to create an append query to add the data
although some (but again not all) of the data would be added to existing
records and some data could be new records. There will be a field in the
Excel data that matches a field in the table. I'm not too hot on VBA code so
if that is the root an ABC description of the steps would be appreciated.
Many thanks
Tony
not all) the fields in one of the tables of a database. I know that it is
possible to import these using the wizard but I wondered whether there was
any way to automate the process. For example, ideally I would like a command
button that I clicked which opened up the Windows Explorer Browse window,
allowed me to browse for the file and, when found, the data would be
automatically added to the table when, say, the Explorer window is closed.
I'm assuming that I would have to create an append query to add the data
although some (but again not all) of the data would be added to existing
records and some data could be new records. There will be a field in the
Excel data that matches a field in the table. I'm not too hot on VBA code so
if that is the root an ABC description of the steps would be appreciated.
Many thanks
Tony