I get a comma separated file instead of pipe separated. Can anyone provide any recommendations which will allow me to automate saving the selected sheet of the XL file as a pipe delimited file?
ASKER
ASKER
IF(A2="Y","Hello","Bye")
, you need this
IF(A2="Y"|"Hello"|"Bye")
ASKER
declare @SQL nvarchar(max)
set @SQL = 'Bulk Insert #AL FROM ''' + @FilePath + @Filename + ''' ' +
'with (FirstRow = 2, Datafiletype = ''char'', Fieldterminator = ''|'', Rowterminator = ''\n'')'
exec @SQL
WHERE #AL is defined as a temp table with all the fields are defined as nvarchar( ). After importing into this temp table, the SP performs an Append query that performs data type translations between the nvarchar( ) in the temp table and the actual field types in the reporting database table.FORMAT = 'CSV'
FIELDQUOTE = '"'
ASKER
ASKER
ASKER
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
TRUSTED BY