Exporting Excel file to Access 2002

[Alex Martinez]

I am using Excel 2002. My users are not techies at all. I have a Excel
file in H: directory - H:\Access\User\Upload\Audit Upload.XLS This Excel
file will be properly formatted and will have the correct fields before
exporting to Access. Is there a way I can export the Excel file using a
macro to Access? Can someone give me the code in exporting the Excel file
or point to me a website or reference book. The Excel file will be exporting
to Access - H:\Access\User\Audit.mdb. I want to have a macro button so the
user simply press the button and the Excel file will exported and
acknowledge that the export has been done so the user don't press the button
again. I don't know if this is possible. I most likely have to create a
macro in Access. Any tips or help will be appreciated. Thank you.

 

[Andy Wiggins]

This might be a help for getting data to and from Excel and Access: It
includes examples of using variables in SQL queries.
http://www.bygsoftware.com/examples/sql.html

Or you can get there from the "Excel with Access Databases" section on page:
http://www.bygsoftware.com/examples/examples.htm

It demonstrates how to use SQL in Excel's VBA to:

* create a database,
* create a table
* insert records
* select records,
* update records,
* delete records,
* delete a table,
* delete a database.

DAO and ADO files available.

You can also download the demonstration file called "excelsql.zip".

The code is open and commented.

 

[Andy Wiggins]

Also, take a look at this link:
http://office.microsoft.com/en-us/assistance/HA012013211033.aspx

 

[Alex Martinez]

Thanks Andy,
Your tip came in handy.

Regards

Also, take a look at this link:
http://office.microsoft.com/en-us/assistance/HA012013211033.aspx

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-