Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Access from Excel using ADO
Hi,
I don't have an answer for you - but I really need to know how to add data from Excel to an Access Database. Please respond. Thanks. Cindy -----Original Message----- Hello, please help if you can. I am using ADO to add data from Excel to an Access Database. I am successful so far. I only need to add two things: 1. How can I add an "AutoNumber" column using ADO? 2. When adding fields to a table, how can I tell Access that the field may be null (equivalent to setting "Required" to no) using ADO? Your example code would be most appreciated. Thanks in advance for your assistance. . |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Access from Excel using ADO
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. DAO and ADO files available. 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" "Cindy" wrote in message ... Hi, I don't have an answer for you - but I really need to know how to add data from Excel to an Access Database. Please respond. Thanks. Cindy -----Original Message----- Hello, please help if you can. I am using ADO to add data from Excel to an Access Database. I am successful so far. I only need to add two things: 1. How can I add an "AutoNumber" column using ADO? 2. When adding fields to a table, how can I tell Access that the field may be null (equivalent to setting "Required" to no) using ADO? Your example code would be most appreciated. Thanks in advance for your assistance. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Query from Access into Excel cause Access to go to read only | Excel Discussion (Misc queries) | |||
Can Excel access data from Access?! | Excel Discussion (Misc queries) | |||
Access Form In An Access Report (SubForm) Question | Links and Linking in Excel | |||
export access to excel. change access & update excel at same time | Excel Discussion (Misc queries) | |||
How to access ACCESS from Excel! | Excel Programming |