Interesting.... Use the Excel ODBC. It is a one-time conversion. It is not
like we will be keeping it hot forever.
I will give it a try.
Thanks,
Phil
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 02, 2001 6:15 PM
> To: [EMAIL PROTECTED]
> Subject: RE: ODBC Connection to SQLSERVER
>
> Hi Phil,
>
> In that case you could always connect to the SQLServer database with Excel
> and the save out the data as CSV.
>
> Ben Johansen
> www.pcforge.com
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 02, 2001 2:41 PM
> To: [EMAIL PROTECTED]
> Cc: Bill Dorsey
> Subject: RE: ODBC Connection to SQLSERVER
>
> I was afraid that you would say that. The Server is in Virginia and
> I am in Atlanta. But, if this is what has to be done, then I will do it.
> Thanks for you expedient reply.
> Phil
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 02, 2001 4:43 PM
> To: [EMAIL PROTECTED]
> Subject: RE: ODBC Connection to SQLSERVER
>
> Hi
>
> Create Views on SQL Sever with Alias names <= 18 chacters
> that are also not in the ANSI list (CODE [short for codelock], Etc). that
> match the field in SQLServer 1-for-1 and make sure the alias names are
> different that the receiving R:Base table column names.
>
> then once you have sattached the table, then use the project
> statement to create an rbase table.
>
> project TempRBTable from SQLAttachedTable using *
>
> Now you will have a table that you can use in R:Base to
> complete the process of getting the data into the R:Base Tables.
>
>
> Ben Johansen
> www.pcforge.com
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 02, 2001 1:16 PM
> To: Rbase-L
> Subject: ODBC Connection to SQLSERVER
>
> I connected to a SQLSERVER database through our LAN.
> I was able to attach the table and can view the data.
> The problem that is unresolved is: not all the
> columns came in because of illegal names. Apparently the allowable size
> of the column names on SQLSERVER is greater than the column size in RBase.
> I need the approximately eight tables to have valid data. Has anyone had
> this moving experience? What did you do?
>
> Appreciate any help,
> Phil
> NCSGroup
winmail.dat
