Headings in a linked Excel table are in 3rd row

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

Guest

Hi,

I am creating a database that links to an Excel table. The Excel table has
row headings, but they are in the third row, not the first. When I create
the table link using the wizard, Access asks me if the first row contains
headers, but there does not seem to be an option to select the third row as
the location of row headers. The information in the first and second rows is
irrelevant to my database, but I cannot delete them in the Excel table
because it is not my table to mess with.

Is there any way I can link to this table but exclude the information in the
first two rows and use the headings in the third row?

Thanks!!
 
Hi bejewell - did you let the link finish? I just did a quick test and
although it asked if the first row contained the headers it displayed the
data from row 3 down and linked fine.
 
Thanks for responding so quickly!!

I just tried it again, and it still did not work. The first two rows are
merged cells that just contain heading information. I did not check the
"first row contains headers" box. When the table finishes linking, it shows
all of the rows, but I don't know how to change it so that the info in rows 1
and 2 is not included and the entries in row 3 are recognized as the
headings. There may not be any way to do this, but it seems like it would
be a pretty obvious need, to link to certain rows in a table instead of just
the entire table.

Any options you can suggest?
 
How's about making a copy of your spreadsheet & deleting the first two rows.

If your need to keep it up to date w/ changes made in the spreadsheet, you
could write a small script to copy it for ya.
 
I have not had real go results with linking to spreadsheets. - I tend
to have more problems with the default data types that it generates.

Also I believe that Access will not really allow updates back into the
spreadsheet. Given that current (or future) limitation I have done the
following when importing but it will work for linking also.

1) Create a process to acquire the spreadsheet data that includes the
following.

A) copy the original spreadsheet to a new name.
B) Unlink (if a linked file) or empty if you will import it.
C) open the spreadsheet from within Access and delete the first 2 rows.
D) Close the spreadsheet.


E) then set up the link or the import.

Ron
 
Back
Top