Re: Error using ado to read cvs file

Thanks Bob.

I thought of your suggestion before, but this method will run into collision
problem if more than a few users are doing the importing at the same time.
Of course, we could always wait for the previous one to complete but on the
server, it is not an option.


"Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx> wrote in message
news:OiP1fcH$HHA.4200@xxxxxxxxxxxxxxxxxxxxxxx
Upload the files into a staging folder. Then loop through them, moving
them one-at-a-time into the folder containing the schema.ini file,
renaming them in the process. Read the contents using ado, rename the
file back to the original name and move into a "completed folder" and go
to the next file.

Light wrote:
Thanks ek.

Our web application allows users to upload csv file to the server
before the data in the fles are imported to the server.

Obviously, the file names will be different, thus the requirement for
the wild card .



.

Relevant Pages

  • Re: Please HELP! text import problems.
    ... >> I have been having difficulties for many months now when importing text ... >> that is exported from SAP then FTP's from a UNIX server to my SQL server. ... >> I do not want to load multi language support on may local maching or ...
    (microsoft.public.sqlserver.dts)
  • Text file, SAP and multi language support problems????
    ... I have been having difficulties for many months now when importing text data ... that is exported from SAP then FTP's from a UNIX server to my SQL server. ... contains 6 columns and the first row contains data only in the first 5 ...
    (microsoft.public.sqlserver.dts)
  • Please HELP! text import problems.
    ... I have been having difficulties for many months now when importing text data ... that is exported from SAP then FTP's from a UNIX server to my SQL server. ... contains 6 columns and the first row contains data only in the first 5 ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS transformation task loads partial data and succeeds
    ... odd...is it possible that dts works differently on a server than when running ... "Allan Mitchell" wrote: ... be needed for importing such a large amount of data? ... than what is being imported within DTS ...
    (microsoft.public.sqlserver.dts)
  • Re: import 100+ tables from ACCESS to SQL Server w/ same structure
    ... Creating 100 data pump tasks is not feasible and linked server is not an option for me either. ... In the DTS, there are two connections (one for Access, one for SQL Server) and one task (importing one table). ... Dim oTask ...
    (microsoft.public.sqlserver.dts)