The BULK INSERT is not carried out if I CFINCLUDE the following into a
template:
<!--- Read raw data from file --->
<cfquery name="bulkin" datasource="golfdata" username="" password="">
BULK INSERT MarketUpdate
FROM 'D:\website\htdocs\stockgolf\htdocs\data\eod.txt'
WITH
(
FIELDTERMINATOR=',',
ROWTERMINATOR='
'
)
</cfquery>
But THE SAME Bulk Insert as above works if I do it from Query Analyzer.
Any suggestions would be appreciated.
best, paul
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
