Search results

  1. N

    Make Table to CSV, Remove Text Qualifier

    Thanks for looking! I'm using a query to export a table to a text file, i.e. SELECT * INTO [Text;HDR=No;Database=C:\].[test#txt] FROM [TestTbl] Text fields end up surrounded by double quotes as a text qualifier. Is there a property I can use to get rid of the text qualifier within the SQL...
  2. N

    Dynamic query based on "formulas" stored in table

    Hi, I have a table that looks something like this: Company Product Sales 1 A 5 1 B 2 1 C 7 2 A 8 2 B 1 2 C 2 I want a query to produce a table showing...
Back
Top Bottom