export wizard blank (no sample data)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've done this many times and suddenly I cannot export a query in datasheet
view to a text file. I have the latest jet updates. The original database was
2000 format. The wizard is not working even after converting the database to
2003 format. When I run the query and open the export wizard, the window is
blank. Security is set to low. I can select all and paste into an Excel sheet
as a workaround, but this one has me stumped. Thoughts?
 
Hi Michael,

Probably you need to re-register ACCWIZ.DLL.

If after that the import wizard still isn't working, re-register the
following files
msexcl40.dll (Excel)
msxbse40.dll (dBase)
mspdox40.dll (Paradox)
mstext40.dll (Text, CSV, tab-delimited))
In Access 97, the filenames contain 35 instead of 40.

To re-register a DLL file,

1) Locate it (usually all these are in the Windows\System32 or
WINNT\System32 folder.

2) Locate the file regsvr32.exe.

3) Drag the DLL file's icon onto the regsvr32.exe icon.
 
Hi, John. Thanks for responding.

I ran regsvr32 on accwiz.dll and mstext40.dll from the command line and got
success messages. Problem persists. Do you think the other three DLLs are
necessary? I don't think they're involved--are they?

I have a feeling this something really dumb and obvious on my part.
 
If it is something dumb and obvious, I haven't spotted it.

A couple of things to try:

1) Click on the query in the Database window. Don't open it, just
right-click and select Export, then set about exporting to a text file.
Does the wizard run normally and export the file?

2) Export the query to Excel. Any problems?

3) Try exporting without using the wizard (either use DoCmd.TransferText
in VBA, or the TransferText macro action). What happens?
 
The same happen to me too. Although the text file is coma delimited I
always need a Specification File or a schema.ini witch solve that
problem.

[]'s
BD
 
Back
Top