Skip to Content
author's profile photo Former Member
0
Former Member

Error While loading into PAS from Excel File

Posted on Mar 07, 2014 at 02:53 PM 14 Views

Hi Friends

The following is the procedure created and executed

CLEAR STATUS

SET PERIOD Monthly

SET PERIOD Jan 2013 - Dec 2013

SELECT VAR PROFIT

SELECT COMPANY INPUT

ACROSS VARIABLE DOWN COMPANY,TIME

ACCESS LSLINK

CONNECT MyXLLink

SELECT * FROM PASDATA

PEEK ONLY 4

READ

END

I got below error; Pl suggest . (Excel Data also enclosed in screen shot)

SriG

loading error.jpg (189.8 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Mar 07, 2014 at 04:32 PM
    0

    Hi,

    Did you tested the lslink? is working?

    Is the excel file closed?

    Miguel

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 10, 2014 at 06:59 AM
    0

    Select from <rangename>

    where <rangename> is a named range in the workbook PASDATA.XLS. It looks as if you selected from the workbook name rather than the range name.


    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member
      Mar 13, 2014 at 10:42 PM

      Access LSLink has a trap. Each entry to the access subsystem must be matched by an exit. If a job crashes part way through (and in development this is common) you are often left in the access subsystem. This subsystem has a different set of commands.

      If you select a dimension (a valid PAS command) it will think you are issuing a SQL Select and complain you did not specify a table name. This is one of the errors in your screen shot.

      If you try to rerun the job the "access lslink" command will throw an error saying you can't issue an access lslink command from within the access subsystem. This was another error in your screen shot.

      Issue and end command to ensure you are out of the system prior to rerunning the proc. Look at the status bar in the bottom of the screen. It will tell you if you're in the access subsystem.

      This issue will be compounding your original problem. Once you run from PAS (not Access) you can return to sorting the original issue.

    Comment on This Answer

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.