Here's a shocker

Mike Labosh · Oct 26, 2004

Last night, I was hacking around in Access trying to export a huge txt file
for use with testing a project I'm working on in .NET / SQL Server. So I
was at home, working at my laptop, watching the matrix and getting kind of
drunk. That's probably why I can't reproduce this behavior...

This morning when I got to work, I found a file in the same folder where I
had exported my text file. I don't know how Access made this, and I've
never even heard of this, but it looks like an execution plan (similar to
SQL Server Query Analyzer Execution Plan) generated while I was in the
Import / Export wizard. Any thoughts?

showplan.out file:
============

--- qselExportSoftware ---

- Inputs to Query -
Table 'Software'
Database
'C:\Data\Projects\GiantWebApp\Documentation\Sample\Software.mdb'
- End inputs to Query -

01) Restrict rows of table Software
by scanning
testing expression "Not IIf(Left$(Nz([Prod_name]),11)="1 =
Running",Right$(Nz([Prod_name]),Len(Nz([Prod_name]))-11),[Prod_name]) Is
Null And (Not Software.Contact_phone Is Null And (Not Software.Contact_job
Is Null And (Not Software.Customer_contact Is Null And (Not
Software.Customer_title Is Null And (Not Software.Op"

--- qselExportSoftware ---

- Inputs to Query -
Table 'Software'
Database
'C:\Data\Projects\GiantWebApp\Documentation\Sample\Software.mdb'
- End inputs to Query -

01) Restrict rows of table Software
by scanning
testing expression "Not IIf(Left$(Nz([Prod_name]),11)="1 =
Running",Right$(Nz([Prod_name]),Len(Nz([Prod_name]))-11),[Prod_name]) Is
Null And (Not Software.Contact_phone Is Null And (Not Software.Contact_job
Is Null And (Not Software.Customer_contact Is Null And (Not
Software.Customer_title Is Null And (Not Software.Op"

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using rushmore
for expression "specID=0"
02) Sort result of '01)'

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using index 'specID'
for expression "SpecID=0"
02) Delete

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using rushmore
for expression "specID=0"
02) Sort result of '01)'

--- temp query ---

- Inputs to Query -
Table 'msysimexspecs'
- End inputs to Query -

01) Sort table 'msysimexspecs'

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using index 'specID'
for expression "SpecID=0"
02) Delete

--- temp query ---

- Inputs to Query -
Table 'MSysImexColumns'
- End inputs to Query -

01) Restrict rows of table MSysImexColumns
using rushmore
for expression "SpecID=1"
02) Sort result of '01)'

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using index 'specID'
for expression "SpecID=1"
02) Delete

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using rushmore
for expression "specID=1"
02) Sort result of '01)'

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using index 'specID'
for expression "SpecID=0"
02) Delete

--- qselExportSoftware ---

- Inputs to Query -
Table 'Software'
Database
'C:\Data\Projects\GiantWebApp\Documentation\Sample\Software.mdb'
- End inputs to Query -

01) Restrict rows of table Software
by scanning
testing expression "Not IIf(Left$(Nz([Prod_name]),11)="1 =
Running",Right$(Nz([Prod_name]),Len(Nz([Prod_name]))-11),[Prod_name]) Is
Null And (Not Software.Contact_phone Is Null And (Not Software.Contact_job
Is Null And (Not Software.Customer_contact Is Null And (Not
Software.Customer_title Is Null And (Not Software.Op"

--- qselExportSoftware ---

- Inputs to Query -
Table 'Software'
Database
'C:\Data\Projects\GiantWebApp\Documentation\Sample\Software.mdb'
- End inputs to Query -

01) Restrict rows of table Software
by scanning
testing expression "Not IIf(Left$(Nz([Prod_name]),11)="1 =
Running",Right$(Nz([Prod_name]),Len(Nz([Prod_name]))-11),[Prod_name]) Is
Null And (Not Software.Contact_phone Is Null And (Not Software.Contact_job
Is Null And (Not Software.Customer_contact Is Null And (Not
Software.Customer_title Is Null And (Not Software.Op"

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using rushmore
for expression "specID=0"
02) Sort result of '01)'

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using index 'specID'
for expression "SpecID=0"
02) Delete

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using rushmore
for expression "specID=0"
02) Sort result of '01)'

--- temp query ---

- Inputs to Query -
Table 'msysimexspecs'
- End inputs to Query -

01) Sort table 'msysimexspecs'

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using index 'specID'
for expression "SpecID=0"
02) Delete

--- temp query ---

- Inputs to Query -
Table 'MSysImexColumns'
- End inputs to Query -

01) Restrict rows of table MSysImexColumns
using rushmore
for expression "SpecID=1"
02) Sort result of '01)'

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using index 'specID'
for expression "SpecID=2"
02) Delete

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using rushmore
for expression "specID=2"
02) Sort result of '01)'

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using index 'specID'
for expression "SpecID=0"
02) Delete

--- qselExportSoftware ---

- Inputs to Query -
Table 'Software'
Database
'C:\Data\Projects\GiantWebApp\Documentation\Sample\Software.mdb'
- End inputs to Query -

01) Restrict rows of table Software
by scanning
testing expression "Not IIf(Left$(Nz([Prod_name]),11)="1 =
Running",Right$(Nz([Prod_name]),Len(Nz([Prod_name]))-11),[Prod_name]) Is
Null And (Not Software.Contact_phone Is Null And (Not Software.Contact_job
Is Null And (Not Software.Customer_contact Is Null And (Not
Software.Customer_title Is Null And (Not Software.Op"

--- qselExportSoftware ---

- Inputs to Query -
Table 'Software'
Database
'C:\Data\Projects\GiantWebApp\Documentation\Sample\Software.mdb'
- End inputs to Query -

01) Restrict rows of table Software
by scanning
testing expression "Not IIf(Left$(Nz([Prod_name]),11)="1 =
Running",Right$(Nz([Prod_name]),Len(Nz([Prod_name]))-11),[Prod_name]) Is
Null And (Not Software.Contact_phone Is Null And (Not Software.Contact_job
Is Null And (Not Software.Customer_contact Is Null And (Not
Software.Customer_title Is Null And (Not Software.Op"

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using rushmore
for expression "specID=0"
02) Sort result of '01)'

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using index 'specID'
for expression "SpecID=0"
02) Delete

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using rushmore
for expression "specID=0"
02) Sort result of '01)'

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using rushmore
for expression "SpecID=0"
02) Sort result of '01)'

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using rushmore
for expression "SpecID=0"
02) Sort result of '01)'

--- temp query ---

- Inputs to Query -
Table 'MSysImexColumns'
- End inputs to Query -

01) Restrict rows of table MSysImexColumns
using index 'PrimaryKey'
for expression "SpecID=17"
02) Delete

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using rushmore
for expression "SpecID=0"
02) Sort result of '01)'

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using index 'specID'
for expression "SpecID=0"
02) Delete

--- qselExportSoftware ---

- Inputs to Query -
Table 'Software'
Database
'C:\Data\Projects\GiantWebApp\Documentation\Sample\Software.mdb'
- End inputs to Query -

01) Restrict rows of table Software
by scanning
testing expression "Not IIf(Left$(Nz([Prod_name]),11)="1 =
Running",Right$(Nz([Prod_name]),Len(Nz([Prod_name]))-11),[Prod_name]) Is
Null And (Not Software.Contact_phone Is Null And (Not Software.Contact_job
Is Null And (Not Software.Customer_contact Is Null And (Not
Software.Customer_title Is Null And (Not Software.Op"

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using rushmore
for expression "specID=0"
02) Sort result of '01)'

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using index 'specID'
for expression "SpecID=0"
02) Delete

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using rushmore
for expression "specID=0"
02) Sort result of '01)'

--- temp query ---

- Inputs to Query -
Table 'msysimexspecs'
- End inputs to Query -

01) Sort table 'msysimexspecs'

--- temp query ---

- Inputs to Query -
Table 'MSysImexColumns'
- End inputs to Query -

01) Restrict rows of table MSysImexColumns
using index 'PrimaryKey'
for expression "SpecID=1"
02) Delete

--- temp query ---

- Inputs to Query -
Table 'msysimexspecs'
- End inputs to Query -

01) Sort table 'msysimexspecs'

--- temp query ---

- Inputs to Query -
Table 'MSysImexColumns'
- End inputs to Query -

01) Restrict rows of table MSysImexColumns
using index 'PrimaryKey'
for expression "SpecID=10"
02) Delete

--- temp query ---

- Inputs to Query -
Table 'msysimexspecs'
- End inputs to Query -

01) Sort table 'msysimexspecs'

--- temp query ---

- Inputs to Query -
Table 'MSysImexColumns'
- End inputs to Query -

01) Restrict rows of table MSysImexColumns
using index 'PrimaryKey'
for expression "SpecID=11"
02) Delete

--- temp query ---

- Inputs to Query -
Table 'msysimexspecs'
- End inputs to Query -

01) Sort table 'msysimexspecs'

--- temp query ---

- Inputs to Query -
Table 'MSysImexColumns'
- End inputs to Query -

01) Restrict rows of table MSysImexColumns
using index 'PrimaryKey'
for expression "SpecID=15"
02) Delete

--- temp query ---

- Inputs to Query -
Table 'msysimexspecs'
- End inputs to Query -

01) Sort table 'msysimexspecs'

--- temp query ---

- Inputs to Query -
Table 'MSysImexColumns'
- End inputs to Query -

01) Restrict rows of table MSysImexColumns
using index 'PrimaryKey'
for expression "SpecID=3"
02) Delete

--- temp query ---

- Inputs to Query -
Table 'msysimexspecs'
- End inputs to Query -

01) Sort table 'msysimexspecs'

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using index 'specID'
for expression "SpecID=0"
02) Delete

--- temp query ---

- Inputs to Query -
Table 'MSysImexColumns'
- End inputs to Query -

01) Restrict rows of table MSysImexColumns
using rushmore
for expression "SpecID=17"
02) Sort result of '01)'

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using index 'specID'
for expression "SpecID=17"
02) Delete

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using rushmore
for expression "specID=17"
02) Sort result of '01)'

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using rushmore
for expression "SpecID=17"
02) Sort result of '01)'

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using index 'specID'
for expression "SpecID=17"
02) Delete

--- qselExportSoftware ---

- Inputs to Query -
Table 'Software'
Database
'C:\Data\Projects\GiantWebApp\Documentation\Sample\Software.mdb'
- End inputs to Query -

01) Restrict rows of table Software
by scanning
testing expression "Not IIf(Left$(Nz([Prod_name]),11)="1 =
Running",Right$(Nz([Prod_name]),Len(Nz([Prod_name]))-11),[Prod_name]) Is
Null And (Not Software.Contact_phone Is Null And (Not Software.Contact_job
Is Null And (Not Software.Customer_contact Is Null And (Not
Software.Customer_title Is Null And (Not Software.Op"

--- temp query ---

- Inputs to Query -
Table 'Software'
Database
'C:\Data\Projects\GiantWebApp\Documentation\Sample\Software.mdb'
- End inputs to Query -

01) Restrict rows of table Software
by scanning
testing expression "Not IIf(Left$(Nz([Prod_name]),11)="1 =
Running",Right$(Nz([Prod_name]),Len(Nz([Prod_name]))-11),[Prod_name]) Is
Null And (Not Software.Contact_phone Is Null And (Not Software.Contact_job
Is Null And (Not Software.Customer_contact Is Null And (Not
Software.Customer_title Is Null And (Not Software.Op"
02) Select into 'software msm 1252 isoalpha2code 20041025#txt'

Sylvain Lafontaine · Oct 26, 2004

Yes, they are options in the ODBC and OLEDB provider to create this
showplan. Which provider, wizard or procedure did you follow to export your
text file?

For an exemple with Jet, take a look at:
http://builder.com.com/5100-6388-5064388.html

S. L.

Mike Labosh said:
Last night, I was hacking around in Access trying to export a huge txt
file for use with testing a project I'm working on in .NET / SQL Server.
So I was at home, working at my laptop, watching the matrix and getting
kind of drunk. That's probably why I can't reproduce this behavior...

This morning when I got to work, I found a file in the same folder where I
had exported my text file. I don't know how Access made this, and I've
never even heard of this, but it looks like an execution plan (similar to
SQL Server Query Analyzer Execution Plan) generated while I was in the
Import / Export wizard. Any thoughts?

showplan.out file:
============

--- qselExportSoftware ---

- Inputs to Query -
Table 'Software'
Database
'C:\Data\Projects\GiantWebApp\Documentation\Sample\Software.mdb'
- End inputs to Query -

01) Restrict rows of table Software
by scanning
testing expression "Not IIf(Left$(Nz([Prod_name]),11)="1 =
Running",Right$(Nz([Prod_name]),Len(Nz([Prod_name]))-11),[Prod_name]) Is
Null And (Not Software.Contact_phone Is Null And (Not Software.Contact_job
Is Null And (Not Software.Customer_contact Is Null And (Not
Software.Customer_title Is Null And (Not Software.Op"

--- qselExportSoftware ---

- Inputs to Query -
Table 'Software'
Database
'C:\Data\Projects\GiantWebApp\Documentation\Sample\Software.mdb'
- End inputs to Query -

01) Restrict rows of table Software
by scanning
testing expression "Not IIf(Left$(Nz([Prod_name]),11)="1 =
Running",Right$(Nz([Prod_name]),Len(Nz([Prod_name]))-11),[Prod_name]) Is
Null And (Not Software.Contact_phone Is Null And (Not Software.Contact_job
Is Null And (Not Software.Customer_contact Is Null And (Not
Software.Customer_title Is Null And (Not Software.Op"

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using rushmore
for expression "specID=0"
02) Sort result of '01)'

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using index 'specID'
for expression "SpecID=0"
02) Delete

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using rushmore
for expression "specID=0"
02) Sort result of '01)'

--- temp query ---

- Inputs to Query -
Table 'msysimexspecs'
- End inputs to Query -

01) Sort table 'msysimexspecs'

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using index 'specID'
for expression "SpecID=0"
02) Delete

--- temp query ---

- Inputs to Query -
Table 'MSysImexColumns'
- End inputs to Query -

01) Restrict rows of table MSysImexColumns
using rushmore
for expression "SpecID=1"
02) Sort result of '01)'

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using index 'specID'
for expression "SpecID=1"
02) Delete

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using rushmore
for expression "specID=1"
02) Sort result of '01)'

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using index 'specID'
for expression "SpecID=0"
02) Delete

--- qselExportSoftware ---

- Inputs to Query -
Table 'Software'
Database
'C:\Data\Projects\GiantWebApp\Documentation\Sample\Software.mdb'
- End inputs to Query -

01) Restrict rows of table Software
by scanning
testing expression "Not IIf(Left$(Nz([Prod_name]),11)="1 =
Running",Right$(Nz([Prod_name]),Len(Nz([Prod_name]))-11),[Prod_name]) Is
Null And (Not Software.Contact_phone Is Null And (Not Software.Contact_job
Is Null And (Not Software.Customer_contact Is Null And (Not
Software.Customer_title Is Null And (Not Software.Op"

--- qselExportSoftware ---

- Inputs to Query -
Table 'Software'
Database
'C:\Data\Projects\GiantWebApp\Documentation\Sample\Software.mdb'
- End inputs to Query -

01) Restrict rows of table Software
by scanning
testing expression "Not IIf(Left$(Nz([Prod_name]),11)="1 =
Running",Right$(Nz([Prod_name]),Len(Nz([Prod_name]))-11),[Prod_name]) Is
Null And (Not Software.Contact_phone Is Null And (Not Software.Contact_job
Is Null And (Not Software.Customer_contact Is Null And (Not
Software.Customer_title Is Null And (Not Software.Op"

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using rushmore
for expression "specID=0"
02) Sort result of '01)'

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using index 'specID'
for expression "SpecID=0"
02) Delete

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using rushmore
for expression "specID=0"
02) Sort result of '01)'

--- temp query ---

- Inputs to Query -
Table 'msysimexspecs'
- End inputs to Query -

01) Sort table 'msysimexspecs'

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using index 'specID'
for expression "SpecID=0"
02) Delete

--- temp query ---

- Inputs to Query -
Table 'MSysImexColumns'
- End inputs to Query -

01) Restrict rows of table MSysImexColumns
using rushmore
for expression "SpecID=1"
02) Sort result of '01)'

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using index 'specID'
for expression "SpecID=2"
02) Delete

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using rushmore
for expression "specID=2"
02) Sort result of '01)'

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using index 'specID'
for expression "SpecID=0"
02) Delete

--- qselExportSoftware ---

- Inputs to Query -
Table 'Software'
Database
'C:\Data\Projects\GiantWebApp\Documentation\Sample\Software.mdb'
- End inputs to Query -

01) Restrict rows of table Software
by scanning
testing expression "Not IIf(Left$(Nz([Prod_name]),11)="1 =
Running",Right$(Nz([Prod_name]),Len(Nz([Prod_name]))-11),[Prod_name]) Is
Null And (Not Software.Contact_phone Is Null And (Not Software.Contact_job
Is Null And (Not Software.Customer_contact Is Null And (Not
Software.Customer_title Is Null And (Not Software.Op"

--- qselExportSoftware ---

- Inputs to Query -
Table 'Software'
Database
'C:\Data\Projects\GiantWebApp\Documentation\Sample\Software.mdb'
- End inputs to Query -

01) Restrict rows of table Software
by scanning
testing expression "Not IIf(Left$(Nz([Prod_name]),11)="1 =
Running",Right$(Nz([Prod_name]),Len(Nz([Prod_name]))-11),[Prod_name]) Is
Null And (Not Software.Contact_phone Is Null And (Not Software.Contact_job
Is Null And (Not Software.Customer_contact Is Null And (Not
Software.Customer_title Is Null And (Not Software.Op"

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using rushmore
for expression "specID=0"
02) Sort result of '01)'

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using index 'specID'
for expression "SpecID=0"
02) Delete

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using rushmore
for expression "specID=0"
02) Sort result of '01)'

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using rushmore
for expression "SpecID=0"
02) Sort result of '01)'

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using rushmore
for expression "SpecID=0"
02) Sort result of '01)'

--- temp query ---

- Inputs to Query -
Table 'MSysImexColumns'
- End inputs to Query -

01) Restrict rows of table MSysImexColumns
using index 'PrimaryKey'
for expression "SpecID=17"
02) Delete

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using rushmore
for expression "SpecID=0"
02) Sort result of '01)'

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using index 'specID'
for expression "SpecID=0"
02) Delete

--- qselExportSoftware ---

- Inputs to Query -
Table 'Software'
Database
'C:\Data\Projects\GiantWebApp\Documentation\Sample\Software.mdb'
- End inputs to Query -

01) Restrict rows of table Software
by scanning
testing expression "Not IIf(Left$(Nz([Prod_name]),11)="1 =
Running",Right$(Nz([Prod_name]),Len(Nz([Prod_name]))-11),[Prod_name]) Is
Null And (Not Software.Contact_phone Is Null And (Not Software.Contact_job
Is Null And (Not Software.Customer_contact Is Null And (Not
Software.Customer_title Is Null And (Not Software.Op"

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using rushmore
for expression "specID=0"
02) Sort result of '01)'

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using index 'specID'
for expression "SpecID=0"
02) Delete

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using rushmore
for expression "specID=0"
02) Sort result of '01)'

--- temp query ---

- Inputs to Query -
Table 'msysimexspecs'
- End inputs to Query -

01) Sort table 'msysimexspecs'

--- temp query ---

- Inputs to Query -
Table 'MSysImexColumns'
- End inputs to Query -

01) Restrict rows of table MSysImexColumns
using index 'PrimaryKey'
for expression "SpecID=1"
02) Delete

--- temp query ---

- Inputs to Query -
Table 'msysimexspecs'
- End inputs to Query -

01) Sort table 'msysimexspecs'

--- temp query ---

- Inputs to Query -
Table 'MSysImexColumns'
- End inputs to Query -

01) Restrict rows of table MSysImexColumns
using index 'PrimaryKey'
for expression "SpecID=10"
02) Delete

--- temp query ---

- Inputs to Query -
Table 'msysimexspecs'
- End inputs to Query -

01) Sort table 'msysimexspecs'

--- temp query ---

- Inputs to Query -
Table 'MSysImexColumns'
- End inputs to Query -

01) Restrict rows of table MSysImexColumns
using index 'PrimaryKey'
for expression "SpecID=11"
02) Delete

--- temp query ---

- Inputs to Query -
Table 'msysimexspecs'
- End inputs to Query -

01) Sort table 'msysimexspecs'

--- temp query ---

- Inputs to Query -
Table 'MSysImexColumns'
- End inputs to Query -

01) Restrict rows of table MSysImexColumns
using index 'PrimaryKey'
for expression "SpecID=15"
02) Delete

--- temp query ---

- Inputs to Query -
Table 'msysimexspecs'
- End inputs to Query -

01) Sort table 'msysimexspecs'

--- temp query ---

- Inputs to Query -
Table 'MSysImexColumns'
- End inputs to Query -

01) Restrict rows of table MSysImexColumns
using index 'PrimaryKey'
for expression "SpecID=3"
02) Delete

--- temp query ---

- Inputs to Query -
Table 'msysimexspecs'
- End inputs to Query -

01) Sort table 'msysimexspecs'

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using index 'specID'
for expression "SpecID=0"
02) Delete

--- temp query ---

- Inputs to Query -
Table 'MSysImexColumns'
- End inputs to Query -

01) Restrict rows of table MSysImexColumns
using rushmore
for expression "SpecID=17"
02) Sort result of '01)'

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using index 'specID'
for expression "SpecID=17"
02) Delete

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using rushmore
for expression "specID=17"
02) Sort result of '01)'

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using rushmore
for expression "SpecID=17"
02) Sort result of '01)'

--- temp query ---

- Inputs to Query -
Table 'mx_TblImexCols'
- End inputs to Query -

01) Restrict rows of table mx_TblImexCols
using index 'specID'
for expression "SpecID=17"
02) Delete

--- qselExportSoftware ---

- Inputs to Query -
Table 'Software'
Database
'C:\Data\Projects\GiantWebApp\Documentation\Sample\Software.mdb'
- End inputs to Query -

01) Restrict rows of table Software
by scanning
testing expression "Not IIf(Left$(Nz([Prod_name]),11)="1 =
Running",Right$(Nz([Prod_name]),Len(Nz([Prod_name]))-11),[Prod_name]) Is
Null And (Not Software.Contact_phone Is Null And (Not Software.Contact_job
Is Null And (Not Software.Customer_contact Is Null And (Not
Software.Customer_title Is Null And (Not Software.Op"

--- temp query ---

- Inputs to Query -
Table 'Software'
Database
'C:\Data\Projects\GiantWebApp\Documentation\Sample\Software.mdb'
- End inputs to Query -

01) Restrict rows of table Software
by scanning
testing expression "Not IIf(Left$(Nz([Prod_name]),11)="1 =
Running",Right$(Nz([Prod_name]),Len(Nz([Prod_name]))-11),[Prod_name]) Is
Null And (Not Software.Contact_phone Is Null And (Not Software.Contact_job
Is Null And (Not Software.Customer_contact Is Null And (Not
Software.Customer_title Is Null And (Not Software.Op"
02) Select into 'software msm 1252 isoalpha2code 20041025#txt'

--
Peace & happy computing,

Mike Labosh, MCSD
"I have no choice but to believe in free will."

Mike Labosh · Oct 26, 2004

Yes, they are options in the ODBC and OLEDB provider to create this

showplan. Which provider, wizard or procedure did you follow to export
your text file?

For an exemple with Jet, take a look at:
http://builder.com.com/5100-6388-5064388.html

I wasn't using any OLEDB or ODBC. Is was sitting in Access 2000,
right-clicked a query and hit export, and then wandered through the export
wizard.

This is such an incredibly useful feature, I can't believe Microsoft didn't
publicize it better. I was an MCT for YEARS teaching VB & Access, and this
would have been a killer tip for my countless students!

One of the guys here is the Jedi Master of google and found this too:

http://groups.google.com/groups?hl=...24v53.15109870%40news3.calgary.shaw.ca&rnum=1

Query very slow after compacting	8	Jul 31, 2007
Trying to create a report that will list unmatched records by Ticket Primary Key	0	Mar 11, 2022
Sorting Multiple Tables	1	Apr 14, 2023
How do I increment table entry a specified # of times? 01,02,03	2	Jul 18, 2008
Using DateAdd and IIF conditions in a Query	2	Jun 18, 2013
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key	0	Feb 3, 2023
Criteria Query Error Please Help	4	Mar 18, 2010
Query from expression	2	Mar 16, 2011

Here's a shocker

Mike Labosh

Sylvain Lafontaine

Mike Labosh

Ask a Question

Similar Threads