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

[Axel Klenk]

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]]