How to create a table in MS Access from Labview using ActiveX?

[Jean-Michel]

I want to transfer datas from Labview to Access using activeX method. My only problem is to find out how to create a new table (array) in Access from the Labview program.

Remarks: I use Labview 6i and MS Access 2000.
For the moment I can write and read datas of Access from Labview.

If someone could help me... that would be grate!

[Aaron Marks]

This is off the Microsoft MSDN site "creating an external table". I think you can drop the last step.:

Open the database you want to create the table in. If it is the current database, use the CurrentDb function to return an object variable that represents the current database. If it isn�t the current database, use the OpenDatabase method to open the database you want.
Use the CurrentDb function to create a Database object that points to the current database.
Use the CreateTableDef method of the Database object to create a table definition for the Microsoft Access table.
Use the CreateField method of the TableDef object to create one or more fields in the Microsoft Access table.
Use the Append method of the Fields collection to add the new field or fields t
o the Microsoft Access table.
Use the Append method of the TableDefs collection to create the Microsoft Access table.
Use the TransferDatabase method to create the external table in the specified folder.
Use the Delete method of the TableDefs collection to delete the Microsoft Access table definition.

[Yves]

I have the same problem. I tried to do it with the added description but I failed.
Is there any example available?
thanks for your help
Yves

[Development engineer]

I have the problem of updating my database MS Acess 2000 , to read and write data to access to put into my table. Could somebody please send me example coding @ fnmarais@newelec.co.za .
Thank you.

[L]

On Wed, 7 Aug 2002 02:46:18 -0500 (CDT), Development engineer
wrote:

>I have the problem of updating my database MS Acess 2000 , to read and
>write data to access to put into my table. Could somebody please send
>me example coding @ fnmarais@newelec.co.za .
>Thank you.


if you email me at ieee488@techie.com, i have some sample codes

Linda