A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Here's a shocker



 
 
Thread Tools Display Modes
  #1  
Old October 26th, 2004, 04:33 PM
Mike Labosh
external usenet poster
 
Posts: n/a
Default Here's a shocker

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."


  #2  
Old October 26th, 2004, 04:47 PM
Sylvain Lafontaine
external usenet poster
 
Posts: n/a
Default

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" wrote in message
...
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."



  #3  
Old October 26th, 2004, 05:04 PM
Mike Labosh
external usenet poster
 
Posts: n/a
Default

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=e....ca%26rnum%3D1

--
Peace & happy computing,

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


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:14 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.