I have a very large (3.5 GB) EXCEL spreadsheet that I need to use in my website, but it's too large to open and causes my computer to crash. I want to convert it to SQL so that the file size is lowered and will use less space on the server.
Anyone know how to import .xls into an SQL database without opening the excel file?
EXCEL to SQL
Moderator: General Moderators
-
thegreatone2176
- Forum Contributor
- Posts: 102
- Joined: Sun Jul 11, 2004 1:27 pm
easier said than done...
Opening the file and saving it as a .txt file would work, except I encounter some problems in the file size. Excel will only support up to 65,536 rows in a spreadsheet. Mine has many many more rows, so when I open the file, it won't load the file completely.
If it helps, my file is a .csv file already (comma separated values), not a .xls file like normal excel worksheets. I tried opening the file with notepad, but got an error saying the file was too big for it. I tried wordpad, but it also had an error. What I need is some sort of script in some language that will read my comma separated file and write to a tab delimited file. Then I could load it into an SQL sheet.
Anyone know how to write a script that would read my .csv and write it as .txt? I seem to remember something like that from c++, but can't remember it. Any help would be great. Thanks.
If it helps, my file is a .csv file already (comma separated values), not a .xls file like normal excel worksheets. I tried opening the file with notepad, but got an error saying the file was too big for it. I tried wordpad, but it also had an error. What I need is some sort of script in some language that will read my comma separated file and write to a tab delimited file. Then I could load it into an SQL sheet.
Anyone know how to write a script that would read my .csv and write it as .txt? I seem to remember something like that from c++, but can't remember it. Any help would be great. Thanks.