no advanced options appearing during import/export

k2tile

Registered User.
Local time
Today, 09:54
Joined
Sep 22, 2010
Messages
19
I am trying to follow the instruction at : http://www.btabdevelopment.com/ts/default.aspx?PageId=25 and am not getting the expected results.

After I've selected a file and click OK, the wizard instantly closes out, rather than proceeding to the next step where I would specify the delimiter, etc. Nothing is imported. It doesn't seem to matter whether the source is an excel file or .csv. Also, when I export a table I am not asked for any options either, but the export does work.

All I want to do is create an Export Specification for use by TransferText.

Any idea what's going on? I've googled and searched the board to no avail. I am using Access 2007 that was installed to my computer by someone else (as in I'm not sure if they changed any settings).

Thanks
 
Have you made sure to set the database's location as a trusted location?
 
The access file and source data are all in the same folder, which I added to the trusted location. Still no advanced options...

I am only able to get through the first four screenshots from your tutorial.
 
Are you clicking the first box ("with Formatting") by chance. If I do it in mine, I don't get the option for the Advanced if I do that. If I don't then it opens up the dialog where I can click Advanced.
 
Tried with that checked and unchecked. Can't get to the advanced options either way. :(
 
Can you post some screenshots of each step you are making?
 
Sure...
sc1fc.png



sc2h.png


Then I click OK in that window and nothing happens.
sc1fc.png
 
I can't see your pics because they are blocked by my work. Don't post the pics to an outside sharing site. Those are blocked by my work as well as some other people's. Upload them here and refer to them here. Here are instructions on how to do that.
 
Step 1

attachment.php



Step 2

attachment.php
 

Attachments

  • sc1.png
    sc1.png
    65.3 KB · Views: 687
  • sc2.png
    sc2.png
    82.1 KB · Views: 655

Users who are viewing this thread

Back
Top Bottom