Hello all,
I have an existing table set up. I want to import an Excel spreadsheet (from a download) and append the data to an existing Access table. I do not have field names on it, and I want to import the data this way. When I import the data, Access displays a message saying that the data I have does not have valid field names and that Access will assign them for me. The first row of data is used as field names. Then there is a screen where you can mark a checkbox with "First Row Contains Column Headings." But when I get to that step, it is already selected by default and it is grayed out. Why is this the case? I want to unselect that and just import the raw data. The field values would still line up with the fields in the Access table.
In short, I want to import the raw data w/o field names. Is this possible?