Leading the way in Microsoft Office Development

??

Import Wizard, Text Files ?

You can open single-table database files (.dbf).

You can use Microsoft Query to access many other database file formats.

You can run Microsoft Query directly by selecting (Data > Get External Data > New Database Query).

You can open all types of text files. Just open as usual and you will be prompted with the Text Import Wizard.

You can import data from other file type. Just browse to the file (Import data wizard ?).

Often when you import data, numeric values may appear as numbers but they are actually treated as text.. A quick way to ensure they are all numerical values is to multiply them all by the number "1". Type the value "1" into a cell. Press (Edit > Copy). Highlight the cells containing the data and select (Edit > Paste Special). Click the "multiply" option button and press OK.

You can export the current worksheet although all formatting will be lost except for number formats. To export an Excel file as a text file, select (File > SaveAs) and select from one of the following eight formats:

Things to Remember