Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Jul 2003
    Location
    Park City, Utah
    Posts
    189
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Query Question (2003)

    I'm trying to set up a query to import a comma-delimited file into Excel automatically, but there are no column headings in the file, so when it imports, the first row of data becomes the column headings. Is there a way...to avoid this?

    Thanks!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Query Question (2003)

    Do you mean into Access, perhaps? In Excel, it doesn't matter whether a file has column headings or not.

  3. #3
    2 Star Lounger
    Join Date
    Jul 2003
    Location
    Park City, Utah
    Posts
    189
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Query Question (2003)

    No, I don't have Access. However, I have decided to change how I am getting this data into Excel. I'm just opening it as a CSV file, then have a macro which reorders the columns and formats the data the way I need it. I was just trying to do it using MS Query, but haven't had time to figure it out yet. My original goal was just to write a query to bring it in in the order and format I want, but this will take me a few days to figure out. Ultimately the same data is o8utput in a pipe-delimited format and eventually I'm hopeing to write a query that will get the data from the CSV file and output it to the pipe-delimited format.

    If you know of any good utilities for something like that, let me know.

    Thanks again so much for your efforts.

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Query Question (2003)

    you could create a macro to bring it in and order the way you like. It might be easier to import into excel and then rearrange in excel with a macro

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •