Database to TDMS Converter (Query Help)

[Hooovahh]

So I opened the table in Access, added a field set it to the primary key, set it to AutoNumber, and after having to increase my maximum locks per file, I got an error saying it was larger than the maximum database size, or not enough memory.

Also I did come up with a scheme that worked, sorta.  Attached is another revision of the conversion from a database to TDMS.  It will read the number of rows in a table, then if they are greater than 1000 (contant on BD) it reads 1000 rows one at a time, one cell at a time, using the Move to Next Record.  Then it writes those 1000 samples to TDMS, then queries the next 1000. 

It took an hour to process my 8.7Million row table, and the output file was 980MB TDMS instead of the 1GB database.  I think what this means for me, is I'm going to have to create a specialized solution for the data that is in the database that is needed.  I was hoping I could come up with a more generic solution using TDMS and file/group/channel properties.

EDIT: I'm downloading SQL Express and Management Studio, not sure if adding a column there will be easier, or if there are other options for querying data with it.

[PatrickLye]

This might help with Server Management Studio.

http://superuser.com/questions/51777/connect-to-an-ms-access-database-from-sql-management-studio