Converting .csv file to Database?
 

jlewis

You want to query from within Excel without using Excel?

MSQuery does recognize properly formatted text files as databases. I just
created a csv and used Data - GetExternalData - New Database Query to open
the csv and it recognized the first row as field names. From the Choose
Data Source box, I chose "Text files (not sharable)"

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"jlewis" wrote in message
...
Does anybody have a short way to convert a .csv file to a
database format that can be queried from within Excel
(without using Excel or Access)?

I have a monthly file that consists of about 15k rows of
data, 10 Meg in Excel. I need to run reports across time
however, like 12 to 24 months rolling. I can consolidate
all months into a .csv file, but MS Query doesn't
recognize this as a database. The easy answer is to use
Access, but that isn't an option right now due to some
political concerns within the office (if I leave, nobody
else could support it...)

I tried Word, so far without success. Seems like there's
got to be a round about way for Excel to be able to use
this.