Wednesday, March 28, 2012

Third Party Import Library?

Does anyone know of (or can you recommend) a third party product that
can:
- read from a comma-delimited flat file, and import the data into
SQL server or XML
- Allow users (using a simple interface) to map fields in the flat
file to the SQL db
- Allow concatenation or breaking down of fields in the flat file
to map them to fields in the DB

Of course we could write our own code to do this, but we need to
get this project out as soon as possible.
Please let me know any leads you may have.

Thanks!

Posted Via Usenet.com Premium Usenet Newsgroup Services
------------------
** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
------------------
http://www.usenet.comSure, Microsoft Access and Microsoft Excel can both do all you require :)

Import the file, map the fields to a linked sql server database table(s) and if
you need to, you can use VBA to do the breaking down of the fields ...

Mythran

"cjones42" <sarophes@.yahoo-dot-com.no-spam.invalid> wrote in message
news:40dc5b1b_2@.Usenet.com...
> Does anyone know of (or can you recommend) a third party product that
> can:
> - read from a comma-delimited flat file, and import the data into
> SQL server or XML
> - Allow users (using a simple interface) to map fields in the flat
> file to the SQL db
> - Allow concatenation or breaking down of fields in the flat file
> to map them to fields in the DB
> Of course we could write our own code to do this, but we need to
> get this project out as soon as possible.
> Please let me know any leads you may have.
> Thanks!
>
> Posted Via Usenet.com Premium Usenet Newsgroup Services
> ------------------
> ** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
> ------------------
> http://www.usenet.com

0 comments:

Post a Comment