Uderc programming article aggregator sites

Exporting and Importing a table in Lookout 6.0.2 using Office 2007

Advertisement
I am exporting a table to Excel 2007 from Lookout 6.0.2 so I can make changes and then import the table with changes back into Lookout. I have done this in the past with Excel 2003 and have had no problems. When I export the table the file that is created is an Excel 97-2003 workbook file, so after I make changes to the file in Excel 2007, I save the file as an Excel 97-2003 workbook because that is what is was initially and that is the only type of file Lookout sees when trying to do an import. Problem is when go to import this file I get an error saying 'cannot read file format'.
Any help would be greatly appreciated.
Thanks!
Jason
Jason Phillips
Advertisement
The best answer: Lookout Datatable object can only read worksheet file, but unfortunately Excel 2007 can not save as worksheet any more.
I have not found a way to use datatable with excel 2007 yet.
One workaround is to use ODBC. Refer to this article.
http://digital.ni.com/public.nsf/allkb/C8137C6BDA276982862566BA005C5D1F?OpenDocument
Ryan Shi
National Instruments