How do I get first row of Excel file (heading row)

From: Byron Upchurch (byron_at_iqms.com)
Date: 05/25/04

  • Next message: Del Murray: "Re: Simple TADOQuery is not live" 
    Date: Tue, 25 May 2004 10:59:49 -0700

    An ADO table will regard the first row of an Excel file as the heading row.
    I would like to display the first row in my grid, and supply my own field
    names. Is there a property I can set to show all rows in the Excel file,
    including the first row?

    I am using Delphi 5.

    Thanks in advance.

    Byron

  • Next message: Del Murray: "Re: Simple TADOQuery is not live"

    Relevant Pages

    • Re: Importing Excel, more data type problems
      ... <MS ACCESS MVP> ... those first row values do not need to match the table's field names (but ... two problems importing this data. ... row of the Excel file, ...
      (microsoft.public.access.externaldata)
    • Re: Importing Excel, more data type problems
      ... If you want to use the first row in the EXCEL file as your field names, ... two problems importing this data. ... to automate the wizard process in VBA or any other way to get ...
      (microsoft.public.access.externaldata)
    • Re: Mail Merge
      ... The Excel file I receive is an automated process that I receive every ... Aid Text - FSSL ... first row in the mail merge. ... Row 1- Mack Miller, $10,000 ...
      (microsoft.public.office.misc)
    • Re: Excel Export - Field Names in First Row of Spreadsheet
      ... At the moment I am using TransferSpreadsheet to create the Excel file. ... If I need to include code to open the Excel file (to delete the first row), ... Or use TransferSpreadsheet to export the query, ...
      (microsoft.public.access.externaldata)
    • Text disappears in printing and print preview
      ... I have had a brief look in other posts and can't find the answer. ... get the first little bit of the first row, ... I have checked the cells, they are set to no fill, so it is not an accidental ... It was originally an excel file and I ...
      (microsoft.public.word.tables)