I am trying to figure out the best technologies for a task I have been 

given and I would like some ideas please.  I have to extract data out of 

an .XLS or a .CSV file, do some validation and apply standards against the 

data, then insert the data into a SQL Server 2000 database.  I would like 

to make this process as efficient and scaleable as possible.  The source 

file size is estimated at less than 20,000 records (lines) on average and, 

in the future, may be in other file formats.  Should I use COM, XML, 

BCP, ???



Thank you ahead of time :)

You should use XML, .NET and SQL 2000.



--------------------------------

AAKASH PARMAR

Project Lead

Universal Software

Email : parmarkanaiya@c..., parmarkanaiya@y...

Phone: ++ 91 79 5627740 (R), 630 6028, 630 2998 (O)



----- Original Message -----

From: Tommy Eden <tede461@e...>

To: Application Development <application_development@p...>

Sent: Monday, March 04, 2002 5:45 PM

Subject: [application_development] What technologies to use?





> I am trying to figure out the best technologies for a task I have been

> given and I would like some ideas please.  I have to extract data out of

> an .XLS or a .CSV file, do some validation and apply standards against the

> data, then insert the data into a SQL Server 2000 database.  I would like

> to make this process as efficient and scaleable as possible.  The source

> file size is estimated at less than 20,000 records (lines) on average and,

> in the future, may be in other file formats.  Should I use COM, XML,

> BCP, ???

>

> Thank you ahead of time :)




$subst('Email.Unsub').







_________________________________________________________



Do You Yahoo!?



Get your free @yahoo.com address at http://mail.yahoo.com