database

[ABDULLAH_SH]

Hi,

What I am doing is something like Database example"WritingAndReadingTable.seq". I would like to know if its possible to:

1- Can i login Excel file instead of Access.

2- Every time the seq run, it Drops the  table. How i can keep the old data? is it possible to creat a variable table name?

3- Is it possible to change the font colour in database? i mean if the test fail to write that in a colour and if it pass in other colour in database.

Best regards

Abdullah, 

[Dennis_Knutson]

In theory you could log to Excel since there is an ODBC driver for Excel. I once did an experiment to read and write to Excel and I eventually got it to work but it was a long time ago and don't remember all of the details. I'm pretty sure that you have to create column headers in Excel. I don't think the driver permits to you to create a new table (actually a worksheet in Excel). If you want to write to Excel, I think you would be much better off using ActiveX in a code module.

If you don't want to drop the table, remove the step "Drop Table". You would also want to remove the step called "Create Table".

Yes, if you use access, your table name can be a variable.

In Access, I don't think it is possible to color individual cells or even by rows. With Excel and ActiveX, this would be pretty easy. The easiest way to display pass/fail results in color with Access would be to use a report and not view the raw data.

[ABDULLAH_SH]

Hi Dennis,

Thanks for answering, I ´am pretty new in this field, if you have any example for using ActiveX to write to Excel will be a good help. i have other problem with sending an array to database table. I read that array from a VI, and i can get it right in Teststand, but when i send to access the first nr of the array converted to 1, what ever the nr is( for exm. if the array is: 6700. it will appear as: 1700). do you have any suggestion where is the problem could be?

thanks

[Morini]

Hi, I'm not able to reproduce your problem, maybe you can post your code on this thread, and this link may help you:

http://digital.ni.com/public.nsf/websearch/3FE68BBDA95E845986256DB4006A22C0?OpenDocument