[Emerald] Emerald Question

Michael Whisenant ( (no email) )
Fri, 7 May 1999 21:20:11 -0500

I have a Master Account that is a business, and they are adding an
additional 100-200 email accounts and another 50 or so dial-up accounts.
They have provided me with a text file in the same format as the existing
export for the SubAccounts Table.

Select *
From SubAccounts
Where CustomerID=899
Go

I am lazy or want to be effecient and not have people enter all this data.
Is there a method to update the calls table with this additional
information?

I had though about an Insert statement like

Insert SubAccount
Select *
From ************ What would go here to read a text file?

Another thought I had was something like take the values that are space
delimited, changing them to 'value', and use something like

Insert SubAccounts(login, password, firstname, lastname, phonehome, etc,
etc, etc)
Values (row1 info)
Values (row2 info)etc.....

or maybe

Insert SubAccounts(login, password, firstname, lastname, phonehome, etc,
etc, etc)
Values (row1 info) AND
Values (row2 info) AND
Values (row3 info) etc.....

Any suggestions?