Help With Multiple Tables, Fields and 'query' -

Hello,
I use MS Access 2003 on Win XP (SP2).
I am opening 'exported' (DTS) data from a Solomon DB that has about 1400
tables and from 10 to 50 fields per table (Yuk!).

Several major tables have a 'field name' of NAME and within those
columns (~140,000 rows) I have a 'last name' ~ 'first name' -
importantly I also have a 'client ID' field that must stay 'related' to
the NAME.

I want to take my single column (Field) and bring out the names, rid
myself of the ~ between the last and first name, have it create "two"
fields (Last name, First name) and YET retain my connection with the
"client ID" field for 'importation' back INTO the DATABASE (which uses
the CLIENT ID as the Key).

One "last" complication. In the "name" field there are SOME single named
entries WITHOUT a ~ because they are 'businesses' - I would love to pull
those out and place them in a field called "organization" and ALSO still
retain the "key" relationship.


Any helps is greatly appreciated. Thanks very much.


Doc in "Los Angeles"
mailto: pc-dc-doc@xxxxxxxxxxx
.

Relevant Pages

  • Re: DTS Package throws error on Client Machines only
    ... If my first solution does not work, I will investigate ways to launch a DTS package from a stored procedure which is executed from within SQL Server therefore these client files should not be needed. ... >> Dim strPkgName As String ...
    (microsoft.public.sqlserver.dts)
  • Re: COM object with CLSID {. . . } is either not valid or not regi
    ... (that was the first time I posted to this site, and I got a bogus message saying my post failed -- so I tried again) ... I just kick off the DTS by running a stored procedure on the SQL SERVER. ... The stored procedure is initiated by the client workstation. ... >> Dim strPkgName As String ...
    (microsoft.public.sqlserver.dts)
  • Re: Export more than 65536 records from ADP to excel 2007
    ... But you can also download from MS a free DTS runtime package that lets you run a DTS package on the client. ... I had hoped to be able to export to excel 2007 from an adodb.recordset ...
    (microsoft.public.access.adp.sqlserver)
  • Re: COM object with CLSID {. . . } is either not valid or not register
    ... DTS is a client side tool basically, so have your installed Enterprise ... Manager or the redistributable components of DTS on the client machine? ...
    (microsoft.public.sqlserver.dts)
  • Re: VB Build a DTS Package on the FLY
    ... DTS is exposed as a COM library which should be registered if you've got SQL ... Server client tools installed, I've built one in C# that transferred entire ...
    (microsoft.public.vb.general.discussion)