Skip to content

Populating Created Ms sql server management studio data with text file with no field name

1 message · Paul Bernal

#
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