You need to use the "Mask" qualifier.

This from the GeneralSample.xls

Mask:
Used with the information returned from Info: to access a data file which has Wildcards in the name.

Example: Set GLTrans = Connection.Execute("@L65APST|Mask:PST" )
would return a recordset containing all the records in the GLPST transaction file.

If you have the most recent GL you should use @L80APST as the table name.

Also, for a 12 period GL select only those records where the FP < 13.

Here is a sample SQL

select * from LOCALDATA...[@L80APST|Mask:PST]where FP < 13

Which selects all fields for all ?Special postings? to prior year.