sql server (alternate): sql server 2000 -- sql server (alternate)

sql server 2000

gun_reddy NO[at]SPAM yahoo.com
5/30/2004 11:17:22 PM

sql server (alternate): 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.Operating
system error code 3(the system cannot find the path specified).
Can anyone understand the underlying logic and reply asap.
Thanks
Venkat

Re: sql server 2000

sql NO[at]SPAM hayes.ch
6/1/2004 4:21:16 AM

[quoted text, click to view]

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.