ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Access Editing from Excel (https://www.excelbanter.com/excel-programming/354233-access-editing-excel.html)

[email protected]

Access Editing from Excel
 
I need to add a new table to a current database programatically in
excel. I just don't know where to start any help?

-Justin


Tom Ogilvy

Access Editing from Excel
 
Based on the detailed information provided, try looking at ADO.

http://www.erlandsendata.no/english/...php?t=envbadac

http://support.microsoft.com/default...46&Product=xlw
How To Transfer Data from ADO Data Source to Excel with ADO

http://support.microsoft.com/default...73&Product=xlw
SAMPLE: ExcelADO Demonstrates How to Use ADO to Read and Write Data in Excel
Workbooks

http://support.microsoft.com/default...19&Product=xlw
How To Use ADO with Excel Data from Visual Basic or VBA


--
Regards,
Tom Ogilvy


wrote in message
oups.com...
I need to add a new table to a current database programatically in
excel. I just don't know where to start any help?

-Justin





All times are GMT +1. The time now is 05:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com