Re: [San-Diego-R-users-group] Data help?

From: Kevin D.
Sent on: Saturday, November 24, 2012 4:35 PM
Do you mean you need to import it into SQL? 

BULK INSERT employees FROM ‘c:\path\to\employees.csv’ WITH (
FIELDTERMINATOR = ‘,’,
ROWTERMINATOR = ‘\n’
);
GO

Or do you need a .dat file you can BCP in?


On Sat, Nov 24, 2012 at 2:44 PM, Xavier Leonard <[address removed]> wrote:
Hi-
I have a 90mb file saved as csv and tab delimited text that I need convert ed to SQL format.  Can anyone here help?

--
follow me: @merelyanode




--
Please Note: If you hit "REPLY", your message will be sent to everyone on this mailing list ([address removed])
This message was sent by Xavier Leonard ([address removed]) from San Diego R users group.
To learn more about Xavier Leonard, visit his/her member profile
Set my mailing list to email me As they are sent | In one daily email | Don't send me mailing list messages

Meetup, PO Box 4668 #37895 New York, New York[masked] | [address removed]

Our Sponsors

People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy