home hardware prices news articles forums photos user reviews
Go Back   Tech Support Forums - TechIMO.com > PC Hardware and Tech > Webmastering and Programming
Join TechIMO for Free!
Register Blogs FAQ Members List Calendar Search Today's Posts Mark Forums Read
Reply Get bargains at  »  Dealighted.com
 
Thread Tools
Currently Active Users: 2973
Discussions: 188,378, Posts: 2,243,450, Members: 232,606
Old August 15th, 2002, 03:50 PM   Digg it!   #1 (permalink)
Member
 
Join Date: Jun 2002
Location: Manitoba, Canada
Posts: 77
XLS files into flat files?

Is there a way to get an excel file into a text file, one that could be read to a database? I was thinking of making a c++ program that would essentially take the excel file read it in and output a text file into a format that would be read in the database.

what happens with formula's if there is a way?

thanks

Ram09

Ram09 is offline   Reply With Quote
Old August 15th, 2002, 04:06 PM     #2 (permalink)
Member
 
Imanage's Avatar
 
Join Date: Oct 2001
Location: New York, New York
Posts: 258
You should be able to save the excel spreadsheet as a .CSV file (comma delimited format) field#1,field#2,field#3....etc

Do a file save as and select csv as the format. You should be able to read or import that back into a database.

I don't know what happens with formulas, but save the range that has the values populated.


Last edited by Imanage : August 15th, 2002 at 04:08 PM.
Imanage is offline   Reply With Quote
Old August 15th, 2002, 05:03 PM     #3 (permalink)
Ultimate Member
 
Join Date: Oct 2001
Posts: 21,017
I believe the values would be saved,and not the formulas that generated them. Besides that is better seeing as the database wouldn't understand that they are indeed formulas. The DB would probably treat them as a string and try to insert them as such. Your best bet would be to import all of the values and then do the coding necessary to make sure the values are correct.

vass0922 is online now   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may post new threads
You may post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Most Active Discussions
Is It Just Me? (2883)
The United States Debt (20)
Looks like Burris will get his Sena.. (7)
I think I just killed my computer w.. (24)
Upgrading RAM (5)
Folderchat Weekday thread (439)
Antec 300 bulk purchase? (11)
Worth the upgrade?? (14)
Titan quest and Immortal Throne, an.. (17)
Recent Discussions
dual monitors wont boot (0)
Folderchat Weekday thread (439)
New Build ( Finally ) (0)
MSN Hotmail Down??? (7)
Help with an Ati Radeon HD 4850.. (23)
Laptop waking up itself (0)
CPU wont boot (3)
Best digital camera for under 2.. (13)
Building first computer, will t.. (2)
Blackberry Storm, Gears of War .. (1)
Core 2 Quad Q9550 system (3)
COWBOOM Ripoff! Used Laptop w/$.. (4)


All times are GMT -4. The time now is 08:15 PM.
TechIMO Copyright 2008 All Enthusiast, Inc.



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28