SQL LGS Data Access

DATA IMPORTS IN LGS Every evening, LGS data gets exported to a database named lgs (as opposed to lge).

The database lgs is your Windows Server named LGESQL. This fact sheet, in conjunction with a demonstration at the September 2007 User's meeting, will show you how to access this data using Microsoft Excel. Tab delimited files are created each evening to facilitate this data transfer and these can be accessed from the appropriate network share using Excel.

Armed with these tools following the demonstration you will be able to access and sort existing data in a new way.

[[Media:SQL_LGS_DataAccess.pdf|SQL LGS Data Access]]