Solved

Import Access table to Excel 2010 without column headings

Posted on 2012-03-27
2
251 Views
Last Modified: 2012-03-28
I have an Excel worksheet with 80,000 rows.  I need to update it every month with another 8,000 rows, which come from an Access table. When I use 'Import from Access' how do I stop it from creating another row of headings at the insert point?
0
Comment
Question by:Bellone
2 Comments
 
LVL 9

Accepted Solution

by:
armchair_scouse earned 500 total points
ID: 37772115
I'm intrigued why you are keeping 80,000 rows in Excel, which will grow 8,000 rows a month (96,000 rows per year).  Surely that data is best managed in a database?

In any case, what you could do is the following (this is using Access/Excel 2010):
 - Create a new workbook in Excel and use the Import from Access wizard to get your 8,000 rows onto the sheet
 - Go to Table Style Options and uncheck 'Header Row'
 - Delete the first row
 - Save the workbook.

Now you have a workbook that you can open, go to Table Tools -> Design -> External Table Data ->Refresh, and it will update with the new data, without the headers.  You can then copy the refreshed data without headers and paste it wherever you need.

If you want to be sure that you are only getting new data, go to Table Tools -> Design -> External Table Data ->Properties, and in the form that appears, ensure that 'Overwrite existing cells with data, clear unused cells' is selected.

Hope this helps!
0
 
LVL 5

Author Closing Comment

by:Bellone
ID: 37775479
Thanks - that's what I wanted to know.  (To reassure you, the records do all originate from a database.  For various quite valid reasons, I use Excel for analysis at a remote location, which can't link to the db)
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…

744 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now