This topic is locked

Import Error

1/17/2008 5:39:05 PM
ASPRunnerPro General questions
G
guroos author

I get the following error when trying the import function:
ADODB.Stream error '800a0bbc'
Write to file failed.
/expo/admin/include/commonfunctions.asp, line 2674
This error happens both on local development PC and up at ISP. Everything else appears ok.

5.2 Build 348

Sergey Kornilov admin 1/17/2008

On "Choose pages" screen you choose a folder where temporary upload file will be stored.

Make sure that this folder exists and IUSR_... user has WRITE permissions on this folder.
On your ISP server I recommend to point it to the same folder where your database is stored.

G
guroos author 1/18/2008

On "Choose pages" screen you choose a folder where temporary upload file will be stored.

Make sure that this folder exists and IUSR_... user has WRITE permissions on this folder.
On your ISP server I recommend to point it to the same folder where your database is stored.


Thank you for your response. Locally, the import now tries to import but shows errors. I have tried with both CSV & XLS. I created the file by exporting originally to make sure format was correct. As a troubleshooting step I have reduced the info down to 1 column and 1 line of data, but still get error.
On the ISP the db is in a folder above where the pages are kept. Can I use the "..\" notation?

Sergey Kornilov admin 1/19/2008

Yes, you can use the "..\" notation.
You can post your application to Demo Account and send the URL to support@xlinesoft.com along with Excel/CSV files that won't import.