Re: "load from" and stored procedures

From: Kate Juliff <kcj@mechoshade.com> > >I would like to be able to use "load from filename insert into..." in a >SP but can see that this cannot be done as it isn't "SQL". > >Can anyone suggest a way around this? David, I think this has now become a FAQ! :-) >That is, I have an ascii delimited file that I need to load into a >table. I must do it via ODBC and so must used a stored procedure.... Erm. So you want to have your stored procedure get a file from your local PC via ODBC do you? Anyway, LOAD FROM is a dbaccess function, it isn't anywhere else. I think your best bet would be to ftp the file onto the server and fire up a load on the server. If you must load from the client, you're going to have to cut some code. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com