Microsoft Office Tutorials and References
In Depth Information
FIguRE 5-33 Selection of tables to load from an Excel file.
You can choose the column separator, which by default is a comma, from a list that includes
colon, semicolon, tab, and several other separators. The right choice depends on the format
of the file.
Handling More Complex CSV Files
You might encounter a CSV file that contains fancy separators, and you might find
that the Table Import Wizard cannot correctly load it because you cannot choose just
any characters for the separators and file properties. It might be helpful to use the
schema.ini file, in which you can define advanced properties of the comma separated
file. Please read http://tinyurl.com/SchemaIniPPG to learn this advanced technique for
loading complex data files.