Importing data from an Excel Sheet to Powerhouse

[Jeff Hoffman]

Hi

You could convert the file to fixed length, define it in the 
dictionary, then use qtp to read each record and convert each field 
to fixed length outputing to a subfile.

Another option is to use bcp to load the data into an rdbms. On the 
fly you could create a table, load the data, extract to a subfile if 
necessary when finished you can drop the table. If the table exists 
then something went wrong with the previous load.

Jeff

At 06:51 PM 2/03/2007, you wrote:
>Hello All,
>
>  I've a problem importing data from Excel sheets to power house format.
>  Most of the times, users send data in XLS format, if its a matter of
>  10-20 records, we could do it manually,
>  but its impossible when its a matter 1000 and above records,
>
>  Please suggest a way to do this.
>
>  Thanks and Regards,
>  K Vamsi Krishna
>
>--
>"Nothing is impossible as impossible itself says i m possible"
>--
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l at lists.sowder.com
>Subscribe: "subscribe" in message body to 
>powerh-l-request at lists.sowder.com
>Unsubscribe: "unsubscribe <password>" in message 
>body to powerh-l-request at lists.sowder.com
>http://lists.sowder.com/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.
>Add 'site:lists.sowder.com powerh-l' to your search terms to search 
>the list archive at Google.