Excel Newbie Question: .dbf file import help

LisaExcelHelp · #1 01-24-2015, 01:11 PM

Hi:

I am trying to import a .dbf file into excel. I saved it to my desktop and it says it's 372 MB - compressed size 56 KB. So, I imported, but there are more than 1 million rows, so I can only see part of the data.

Can someone tell me how to import 1 million records at a time, so I can obtain all the data in the file.

I tried opening in Access - wouldn't work. The only way I know to open a .dbf file is to right click and it automatically opens in excel. This is normally fine, but not with such a large file.

Thank you so much for any help you experts can provide.

Lisa

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro to import all diagrams from an excel file	kbka	Word VBA	0	04-15-2013 02:11 AM
Newbie Question	thistlebarrow	PowerPoint	4	04-06-2012 01:46 PM
A newbie question: a must to save macro word file as .docm?	tinfanide	Word VBA	6	12-06-2011 03:02 PM
newbie question	DanSandbergUCONN	Word	5	03-06-2011 04:27 PM
Perhaps a newbie question I know but	as1947	Excel	0	02-05-2009 08:01 AM