Export Wizard will not launch

[jeremiah]

I have tried all the resolutions I can find on the net and still cannot get
the export wizard to launch. I re-registered the dll files, I made sure my
acwztool and main.mde files were installed and can't find a resolution. I
need to export a report to text and the export macro works fine from my PC
but not from other users, it wraps the text differently and have tried
everything I can think of.

Thought I could create a specification but can't seem to get the wizard to
launch to help me through that process. Any ideas would help.

Thanks

 

[Gina Whipp]

Jeremiah,

WHat do you mean by wraps the text differently? Are you saying when you
open it in Word the margins are different from computer to computer?

What export wizard are you refering to? There is File... Export... Are you
looking for something else?

Would also like to know which version of Access.

--
Gina Whipp

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

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

 

[jeremiah]

Yes, from computer to computer the exported report text wraps differently.
Thus when we then try to manipulate the text file in Excel the macros don't
work the same from computer to computer.

We are using 2003 version - We are exporting an access report to a text file
and have used OutPutTo and TransferText with the same results. When trying
to get the wizard to launch I have tried the macros, I have tried right
clicking on the report name, I have tried File, Export and the wizard simply
will not launch so I can make any changes or even create a new specification,
thinking I could somehow reset the width of the report so the text comes out
the same on every computer.

 

[Gina Whipp]

Why are you using Excel to manipulate a text file? Or did you mean Word?
If you meant Excel, why aren't you sending it in .xls format?

I have never seen an Export Wizard you are refering to. As to the wrapping
it might possibly have to do with the way Excel is set up. Perhaps a sample
of waht the data should look like on export would help. Can you type a few
lines here?

--
Gina Whipp

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

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

 

[aaron.kempf]

I would ignore Gina, her answer is to use Jet, no matter how
applicable.

I'd just move to SQL Server and learn a real ETL tool like DTS or SSIS

-Aaron

 

[jeremiah]

I am exporting from Access to .txt and then to Excel because it is an Access
report with formatting, headers, subtotals, all the set up done and complete
and that doesn't export directly to Excel. I have to get it to Excel so that
other users can manipulate the spreadsheet for their own purposes. Those
other users want Excel, not Word. I was trying to avoid exporting the
underlying query. I thought it defeated my purpose to have to perform the
same calculations and formatting in Excel that I have already done in Access,
so I export as much data as possible from Access.

 

[Gina Whipp]

Jeremiah,

Well, then I am afraid you are stuck with that format short of eriting your
own export routine. The only other option that comes to mind is create a
query that does all the calculations your report does and use that in your
export routine.

--
Gina Whipp

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

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

 

[jeremiah]

The export routine is exactly what I am trying to do but being an uneducated,
self-taught vb'r I don't know how to do it without the Access export wizard
guiding me through. I am comfortable enough with VB to give it a shot,
thanks to forums like this but know absolutely nothing about SQL or other
development languages.

 

[Gina Whipp]

Some other posts that might help get you started:

http://groups.google.com/group/comp...b04e?lnk=gst&q=custom+export#ae932573c9dbb04e

http://groups.google.com/group/comp...f874?lnk=gst&q=custom+export#7a90a117e0f5f874

--
Gina Whipp

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

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