Morning All, I have queries that I developed and run in SQL Server that export the results to a Tab delimited text file (no header row). That text file is linked to an Ms Access database using a text file link spec. The same query run in Server 2005 and Server 2008 results in text files that have the same data but structural differences. I have to have a separate spec for 2005 and 2008. Also suprising is that the 2008 version of the text file approx half the physical size. The output of the processing in Access is exactly the same with either version of the text file. Any ideas in what the difference(s) is between 2005 and 2008? Creating two link specs can be pain if the text file contains dozens of fields. Thanks for any Help Gene

Hi All, When I try to enter a command in any of the modules in a MS Access database, the command turns RED. It also constantly moves the cursorn to the left leaving NO spaces. Trying to enter a command such as DoCmd. will open the popup window and then immediately close, and the DoCmd. turns RED. Please tell me what is causing this. The database functions properly, but entering new code is a real pain. Thanks Gene

Thanks for the response, but I get the error message "InCorrect Syntax" It changes CAST(D1.UNIT_RATE AS DECIMAL(10, 2)) AS Rate, to: [CAST](D1.UNIT_RATE AS [DECIMAL](10, 2)) AS Rate, I am working in Visual Web Developer and it seems that not all of the functionality of SQL Server is available. Gene

Does anyone know how to convert a string to a double within the SELECT statement of a SqlDataSource? The data source is a SQL Server database and the values in the fields are all strings. The major problem is that in the Datalist, all of the leading zeros are displayed. Plus I do need to compute one item from three fields. Thanks for you help Gene :omg: