November 22, 2010 at 12:19 pm
I am very new to SQL as most of my experience has been in finance so I would normally use Excel on a daily basis.
Here is my situation. I have 8 text files (.csv) that I would like to combine into one. All the files have the same info in the 2 left columns and contain the same number of rows (7,000). What I would like to do is have a way where I can import each file and then have the program combine them.
When completed there would be about 800 columns.
Is this possible?
November 22, 2010 at 6:27 pm
I am guessing that the 800 columns would be only numbers, am I wright? With 800 different columns? No repetitive (except for the two you mentioned) nor computered columns?
If some columns are computed data, the database would gain profit being in the Thirst Normal Form and having tables for the computerized data...but why not using excel if you are good with it? Excel is a "base" data base and it can do many thing with its macros, isn'it?
November 22, 2010 at 6:43 pm
Import all the 8 file into individual tables (dedicate one table to each file , of course), then prepare a "VIEW" to pull the second column of each table and use.. With a VIEW, you can also INDEX it 🙂
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply