Click here to Skip to main content
15,879,535 members
Home / Discussions / C#
   

C#

 
GeneralRe: ASP.NET is not working Pin
Mamphekgo20-Apr-06 22:28
Mamphekgo20-Apr-06 22:28 
Questionopen IE from win applicatin Pin
mahmoud_sama20-Apr-06 2:42
mahmoud_sama20-Apr-06 2:42 
AnswerRe: open IE from win applicatin Pin
Robert Rohde20-Apr-06 2:58
Robert Rohde20-Apr-06 2:58 
AnswerRe: open IE from win applicatin Pin
Eric Dahlvang20-Apr-06 4:15
Eric Dahlvang20-Apr-06 4:15 
Questionhelp me in creating a table in javascript Pin
umaheshchandra20-Apr-06 0:10
umaheshchandra20-Apr-06 0:10 
AnswerRe: help me in creating a table in javascript Pin
Nick Parker20-Apr-06 3:26
protectorNick Parker20-Apr-06 3:26 
QuestionImporting specific Excel columns Pin
Fendefa20-Apr-06 0:01
Fendefa20-Apr-06 0:01 
AnswerRe: Importing specific Excel columns Pin
Ricardo Casquete20-Apr-06 0:52
Ricardo Casquete20-Apr-06 0:52 
Last time I had to do something like this... thousand of rows in excel files to insert into an Access DataBase...

What I did was.

First, create a typed dataSet with the structure of the Target Tables... ( autogenerate the Insert Command ).

Now the problem is only to fill the DataSet.

Two ways.

First Open the Excel with the COM Object for Excel... and go column by column.... bla bla... and create a row of the DataSet for each row in the Excel file.... and so on..

Second, Export the Excel file to a CSV file and open the txt file from your application and open the file, read line by line and do a split using the ',' the comma, after that do a loop for each line creating a new row of the DataSet...

If there are many lines in the excel files, I recomend you to update every 100 or 200 rows...

Regards

Ricardo Casquete
QuestionHard question may be.))) Pin
papa198019-Apr-06 23:59
papa198019-Apr-06 23:59 
QuestionPage Caching Pin
Brendan Vogt19-Apr-06 23:59
Brendan Vogt19-Apr-06 23:59 
Questiondelete operation in datagrid Pin
rajaaa19-Apr-06 23:21
rajaaa19-Apr-06 23:21 
AnswerRe: delete operation in datagrid Pin
Mamphekgo20-Apr-06 3:19
Mamphekgo20-Apr-06 3:19 
QuestionUsing an Object as a Parameter Pin
__makaveli__19-Apr-06 22:56
__makaveli__19-Apr-06 22:56 
AnswerRe: Using an Object as a Parameter Pin
Le centriste20-Apr-06 7:08
Le centriste20-Apr-06 7:08 
GeneralRe: Using an Object as a Parameter Pin
__makaveli__20-Apr-06 21:50
__makaveli__20-Apr-06 21:50 
Questionhow to implements the WEBTV Pin
ranandbe19-Apr-06 21:29
ranandbe19-Apr-06 21:29 
AnswerRe: how to implements the WEBTV Pin
LongRange.Shooter20-Apr-06 3:43
LongRange.Shooter20-Apr-06 3:43 
AnswerRe: Want to Record Messenger Conversation Pin
LongRange.Shooter20-Apr-06 3:44
LongRange.Shooter20-Apr-06 3:44 
QuestionHow to get process ID by instance ID? Pin
Old Gun19-Apr-06 21:00
Old Gun19-Apr-06 21:00 
QuestionSocket Pin
Shajeel19-Apr-06 20:20
Shajeel19-Apr-06 20:20 
AnswerRe: Socket Pin
Joshua Nussbaum20-Apr-06 14:13
Joshua Nussbaum20-Apr-06 14:13 
Questiona small doubt about dataconversion Pin
jith - iii19-Apr-06 19:46
jith - iii19-Apr-06 19:46 
AnswerRe: a small doubt about dataconversion Pin
Robert Rohde19-Apr-06 22:22
Robert Rohde19-Apr-06 22:22 
QuestionReset record number of a crystal report at the page break Pin
q2sampath19-Apr-06 18:28
q2sampath19-Apr-06 18:28 
AnswerRe: Reset record number of a crystal report at the page break Pin
Sk8tzz19-Apr-06 19:03
Sk8tzz19-Apr-06 19:03 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.