|
|
Posted by carlospedr on 10/01/54 11:41
I will explain,
I started with and excel file, when i imported it to sql server i ended
up with 30 odd tables, everyone of them had different column names
result of different headers in the excel file,
each of them, for some strange reason that i'm still to understand,
with a diferent number of columns but the data was present was allways
present on the first 5 columns
My intention is/was to transform this tables into a RDB, the first sept
i took was to build a sigle table with all the information from these
over 30 tables, i know my script is too say the least un-ortodox but i
do have a very strange representation of the data to start with.
Navigation:
[Reply to this message]
|