Are you using SQL Server or MSDE? MSDE Does have the 2GB database limit so that may be the problem. I use Bulk Insert called from within a VB6 app to insert files with up to 100,000 records daily (no where neae 3 gigs) - and it works OK.
>I'm getting the following error when issuing a Bulk Import with a format file.
>
>"could not allocate space for object '< table name >' in database location because primary
>filegroup is full"
>
>I'm attempting to import about 3 gigs of data ( basically just a flat file ).
>
>I attempted to attach a database of approximately the same size and I recieved the following error.
>
>"Error 1827: CREATE/ALTER DATABASE failed because resulting cumulative database size would exceed your licensed limit of 2048 MB per database."
>
>Is this just a licensing issue?
Al Williams
Anola MB, CANADA