No, I think that BULK INSERT is specific to Transact-SQL (SQL Server).
You might want to check out the Microsoft Jet Database Engine
Programmer’s Guide:
http://msdn.microsoft.com/library/default.asp?URL=/library/books/dnjet/forward.htm
--
Billy Cravens
[EMAIL PROTECTED]
Michael Gagnon wrote:
>
> Hi!
>
> Does anyone know if "BULK INSERT" works
> with a MS-Access 2000 database?
> I have the latest MDAC (2.6) installed.
>
> I get the following error:
> ODBC Error Code = 37000 (Syntax error or access violation)
>
> [Microsoft][ODBC Microsoft Access Driver] Invalid SQL statement;
> expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'
>
> TIA,
> -=-=-=-=-=-=-=-
> Michel Gagnon
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists