Solved

Linking Excel file to Access when the first line doesn't contain column headings

Posted on 2013-12-29
2
301 Views
Last Modified: 2013-12-30
Hi.  I have an Excel file (sample attached) where my heading rows are on the 3rd line.  If I wanted to be able to link this to Access, how do I let it know my column headings aren't in the first row, but rather the third?
sample.xlsx
0
Comment
Question by:daisypetals313
2 Comments
 
LVL 10

Accepted Solution

by:
JEaston earned 500 total points
ID: 39744997
The only way I can see to do what you want is to create a named range.  To do this, in Excel, select the data and the headings.  Then in the box which has the cell reference delete the cell reference and type a name e.g. mydata.

When importing to access you can then choose to import Worksheets or Named Ranges.  Select named ranges, then in the list pick the range you created above.  Then on the next screen tick first row contains headings.
0
 

Author Closing Comment

by:daisypetals313
ID: 39746212
Thanks!  Quick and easy solution and did what I needed.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question