MS SQL Server Connectivity - text file as linked server ('difficult' column delimiter)

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

text file as linked server ('difficult' column delimiter)

inboxart-news@yahoo.ca

2005-08-17, 3:23 am

Is there a way to specify column delimiter when setting up text file as
linked server?

EXEC sp_addlinkedserver NPCRetail,
'Jet 4.0',
'Microsoft.Jet.OLEDB.4.0',
'C:\NPCRetail',
NULL,
'Text;HDR=No;FMT=Del
imited;'

Something like: 'Text; HDR=No, FMT=Delimited; Delimiter = %'

I am trying to import text file into SQL Server but the imported file
has special column delimiter(%).
There are some constraints on the process so I do not want to use
schema.ini file.

Thanks

Art

Sponsored Links