can I see "saved import" as SQL command?

[Joe Stateson]

Access 2007: I would like to view the SQL commands that did the import but
I dont see how to do this. All I see is a "run" command and a right click
on the import name does not list any properties such as "show sql" etc.
Same thing for "export" - no sql commands seem available.

I was hoping to be able to edit the commands to tailor the import to what we
need.

 

[Gina Whipp]

Joe,

Those are wizards that actually create those Import/Export specifications.
I believe the one you are looking for is ACWZLIB.accde. That is why you
can't get to the 'Show SQL' menu.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Joe Stateson]

Joe,

Those are wizards that actually create those Import/Export specifications.
I believe the one you are looking for is ACWZLIB.accde. That is why you
can't get to the 'Show SQL' menu.

yea - it seems you are right. I did a hex dump of the mdb file and looked
for some sql commands and all I found was XML code that simply contained all
the export commands I had typed in.

 

[Gina Whipp]

Joe,

You can write your own, if you so desire but since Access handles it I would
only do so understand extreme cases.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm