>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 )
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement