Get Column Info from ADODB._Connection

[JScherer]

Hello All,

I want to create a VI that will read and access .mdb file and convert it into a SQLite database. Currently, I can create tables and move information between. However, I want to make sure column constraints also transfer (primarily, the primary key).

The Primary Key of each table is most important, but if I can also capture "Not Null," "Auto Incrementing, ect, that would be preferred." Alternately, if I can get the Table creation command, that would work as well.    

[Michael_Munroe]

I believe the Restrictions input is an array of strings.  In your case, the array should contain 4 strings with the table name in the 4th position.

https://learn.microsoft.com/en-us/dotnet/api/system.data.oledb.oledbconnection.getoledbschematable?v...

[JScherer]

---

@Michael_Munroe wrote:

I believe the Restrictions input is an array of strings.  In your case, the array should contain 4 strings with the table name in the 4th position.

https://learn.microsoft.com/en-us/dotnet/api/system.data.oledb.oledbconnection.getoledbschematable?v...

---

I tried the following without success. Any suggestions?

[Michael_Munroe]

Only the middle one is a single variant of an array of 4 strings.  By trying 3 approaches, you are likely to generate 2 errors.  Add wires to the error outputs of the invoke nodes and probe each one.  Are all 3 outputting an error?