import wizard

  1. A

    Microsoft Access Update? Excel Import Wizard no longer rename invalid character to # or blank to NoName

    Hi Guys, First of all I am new here, Here's the problem: Why access no longer rename a blank column or has invalid character such as '.' into NoName or '#'. Is it because update? how to change the preference back to the old one? or maybe I can edit the registry to change it back? I really...
  2. J

    Importing .tab file using Import wizard

    Trying to import a .tab file where specific columns are formatted as text. This is because there is data in the columns where a 0 is at the beginning ie 07256. I want to keep that 0. I tried using the macro recorder and then edited to fit what i need. The 0 keeps dropping off. Here is the...
  3. D

    Open Multiple .txt Files with Same Settings

    I have dozens of .txt files that I want to import into Excel so that they can be formatted, merged, referenced, etc. There are a few columns of data that are formatted in a way that imports them as dates instead of as numbers by default. I've figured out how to import them with the correct...
  4. J

    Table Import Wizard

    I purchased "PowerPivot for the Data Analyst" and downloaded the Sample Data. When I tried to Connect to Flat File to import the demo.txt, I received the message "Failed to connect to the server. Reason: Provider information is missing from the connection string." Since the file is on my C...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top