sql server 2000

[venkat gunreddy]

I am trying to import a text file with an Access 2000 front end
application and
The application has SQL SERVER 2000 as the back end.
when i try to import the text file I am getting the error below.
Could not bult insert because the file could not be opened.Operatin g
system error code 3(the system cannot find the path specified).
Can anyone understand the underlying logic and reply asap.
Thanks
Venkat
gun_reddy@yahoo .com

[Simon Hayes]

Re: sql server 2000

gun_reddy@yahoo .com (venkat gunreddy) wrote in message news:<65653efa. 0405302217.6312 34d9@posting.go ogle.com>...[color=blue]
> I am trying to import a text file with an Access 2000 front end
> application and
> The application has SQL SERVER 2000 as the back end.
> when i try to import the text file I am getting the error below.
> Could not bult insert because the file could not be opened.Operatin g
> system error code 3(the system cannot find the path specified).
> Can anyone understand the underlying logic and reply asap.
> Thanks
> Venkat
> gun_reddy@yahoo .com[/color]

It looks like the error comes from your Access front end - "could not
build insert" is not an MSSQL error, at least as far as I know. The
error about the path seems to indicate that you should investigate the
filename you've provided to make sure it's correct.

But without any code, and without any explanation of how you want to
load the data (build INSERT statements, call bcp.exe, use a DTS
package etc.) then all we can do is guess. You might want to look at
DTS or bcp.exe as an alternative solution.

Simon