Appending Excel file to an Access table
I would like to be able to export an excel speadsheet on
monthly bases by appeding it to an Access table. Since I don't know how long the file would be each month I am wondering if there is any way to write a vb function checking for the end of the file. Ultimately, I would like to have a command button that would append the file to an Access table with vba behind it telling it what the excel file range is so that blank lines don't get exported. I appreciate your time and help. Diana |
Appending Excel file to an Access table
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 and add data to it, * select data from a table, * delete a table, * delete a database. You can also download the demonstration file called "excelsql.zip". The code is open and commented. -- Regards Andy Wiggins www.BygSoftware.com Home of "Save and BackUp", "The Excel Auditor" and "Byg Tools for VBA" "Diana" wrote in message ... I would like to be able to export an excel speadsheet on monthly bases by appeding it to an Access table. Since I don't know how long the file would be each month I am wondering if there is any way to write a vb function checking for the end of the file. Ultimately, I would like to have a command button that would append the file to an Access table with vba behind it telling it what the excel file range is so that blank lines don't get exported. I appreciate your time and help. Diana |
All times are GMT +1. The time now is 06:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com