Linking in Access, Excel column has headings not row.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am linking an Excel spreadsheet within Access, the headings are actually in
the column, not the row as normal. I want them acknowledged to allow me to
query this information. How do I do this? FYI - When importing, I did NOT
choose the option for row headings, thinking I would have other options.
 
Not sure what you mean by "in the column, not the row". Are you saying that,
column A in row 1 has a field name and column B in row 1 has the value for
the field and so on down to Columns A & B in row n?

If that's the case, there's no way that I'm aware of in Access to link to
the table. Perhaps you can create a new sheet in Excel that transposes the
data, and link to that.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Headings in a linked Excel table are in 3rd row 4
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Crosstab query - MS Access 2000 2
Link with Excel 2
Headings to rows in a query 4
link multiple excel files to 1 database 5
How do I put column headings on 2 rows in Access like Excel 4
Excel 2007 List of Materials converted into a report by building 3

Back
Top