2. ASPRunnerPro General questions
  3. Excel Export - Import into Access
This topic is locked

Excel Export - Import into Access

 		4/13/2005 2:42:28 PM
ASPRunnerPro General questions
author

Hi,
I created an ASP page with version 2.4 and made it available to our product management team.
They need to be able to download in Excel and import into Access. However they get the following message when trying to import the file they just exported...
"The wizard is unable to acces the information in the file. Please make sure the file exists and it is in the correct format"
Any idea as to the problem? We use Access 2002 SP3.
Thanks.
Sergey Kornilov admin 4/14/2005

Hi,
the most reliable way is to open exported file in Excel, save it and then import into Access.
501168 4/14/2005

This does work but it prevents them from creating macros to import the data.
I have suggested they use CSV instead as this works well.
Is this issue something that has a fix in the newer versions? I am happy with the version I bought 2.4 but would upgrade for a fix.
Thank You, I really enjoy the simplicity but powerful features of ASP runner.
Sergey Kornilov admin 4/16/2005

ASPRunner creates Excel files that can be open by Excel only. In fact those files are plain HTML files that Excel imports into it's own format. You don't need MS Office installed on the Web server to use this method.
To create real Excel files using ASP you need some kind of third party component that can do this. Also if you have MS Office installed on the Web server you can use ht power of OLE automation to call Excel directly and build fully compliant XLS files that will be opened in MS Access.