WillG

Excel Query Help

I have set up a query in Excel to import data I have set up in an Access Database. It works ok, but in Excel the query returns the column headings. I cannot figure out how to turn that off. Can anyone tell me how to get the query to not return the column heading in Microsoft query

Thanks

SethH

Re: Excel Query Help

Do you use VBA or recorded macros? If you use VBA post your code or PM it to me and I can probably help you out. If nothing else you could probably add a line of code in after you import to delete or hide the first row of the spreadsheet.

WillG

Re: Excel Query Help

Thanks Seth

I actually figured it out. You have to right click in the cell where the query is in and there is an options member from there. Funny how the simplest things can escape you when you're trying to get something done