[R-sig-DB] Populating Created Ms sql server management studio data with text file with no field name

[Paul Bernal]

Dear Axel,

Thank you so much for your valuable help. This information does helps a lot
for sure.

Will try that and let you know how it went.

Best of regards,

Paul
El jun 2, 2014 4:06 AM, "Axel Klenk" <axel.klenk using actelion.com> escribi��:

>
> Dear Paul,
>
> if I had to do that, I would look at function read.fwf() for importing your
> fixed width formatted text file and at package RODBC for connecting
> to your database (or function write.csv() for exporting as a CSV file).
>
> Hope this helps,
>
>  - axel
>
>
> On Fri, May 30, 2014 at 4:40 PM, Paul Bernal <paulbernal07 using gmail.com>
> wrote:
>
>> Hello everyone,
>>
>> I have a text file which has no field name, however, I have a document
>> that
>> says how the fields are sepparated (for example, field ship number goes
>> from position 1 to position 5, field vessel name goes from position 7 to
>> position 15, and so on).
>>
>> I need to populate already created tables (contained in microsoft sql
>> server management studio) with the data contained in this text file .
>> Either that or convert that text file into a csv file so that it can be
>> read in easily.
>>
>> Does R has a function that helps doing this or is there a way that R can
>> help? What options do I have?
>>
>> Best regards,
>>
>> Paul
>>
>>         [[alternative HTML version deleted]]
>>
>> _______________________________________________
>> R-sig-DB mailing list -- R Special Interest Group
>> R-sig-DB using r-project.org
>> https://stat.ethz.ch/mailman/listinfo/r-sig-db
>>
>
>
>
> --
>
>
> Axel Klenk
> Research Informatician
> Information Management Drug Discovery
>
> Actelion Pharmaceuticals Ltd. ��� Gewerbestrasse 16 ��� CH-4123 Allschwil ���
> Switzerland
> H91.O1.W01.2
>
> axel.klenk using actelion.com ��� www.actelion.com
> Address for visitors: Hegenheimermattweg 91
>
>
> The information of this email and in any file transmitted with it is
> strictly confidential and may be legally privileged.
> It is intended solely for the addressee. If you are not the intended
> recipient, any copying, distribution or any other use of this email is
> prohibited and may be unlawful. In such case, you should please notify the
> sender immediately and destroy this email.
> The content of this email is not legally binding unless confirmed by
> letter.
> Any views expressed in this message are those of the individual sender,
> except where the message states otherwise and the sender is authorised to
> state them to be the views of the sender's company. For further information
> about Actelion please see our website at http://www.actelion.com
>
>

	[[alternative HTML version deleted]]