>Dan,
>
>Check your email as I've mailed you some of the chapter 6 example files I mentioned. They are in an Access mdb. There are some DAO functions that crete and manipulate tables. I would have done it earlier but I've just now been able to get back on the UT.
>
>If memory serves the tricky part of createing a table in DAO is that once you create the table (or any object) you must append them to a collection or Access will not see them. Again, get your hands of the book I mentioned it will prove invaluable.
Thanks for the code Tom, we will definitely be able to use it.
Below is the code that I used to import a DBASE table from within FoxPro. This is not exactly what I wanted because this gives me a link to the table. But I believe there is a DoCmd available from the access object and a TransferDatabase command that will do the trick.
oAccess = CreateObject("Access.Application")
oAccess.newcurrentdatabase("d:\Customer2.mdb")
oDb = oAccess.CurrentDb
oTable = oDb.CreateTableDef("Menu")
oTable.Connect = "DBase III;DATABASE=D:\WConnect3.0\"
oTable.SourceTableName= "Menu"
USE D:\IclData\Honda\Menu
COPY TO Menu TYPE FOXPLUS
oDb.TableDefs.Append( oTable )
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only