CODEWITHSUNDEEP
excelms-access
user1255632
user1255632

Reputation: 17

Import Access table into Excel table without first record being Access field labels

This is probably simple but I have been having trouble figuring this out.

I have a MS Excel spreadsheet tool built and I want to import the data from an MS Access table. I got the link to work just fine but the first imported record is the Access field names. Is there a way to skip that and make the first record in Excel the first actual Access record?

Upvotes: 0

Views: 50

Answers (1)

maybeWeCouldStealAVan
maybeWeCouldStealAVan

Reputation: 15610

If you have a named table linked to the data you can just uncheck "Header row" from the table design tab:

enter image description here

Upvotes: 1

Related Questions