Excel and ODBC
This article is intended to give you a couple of lines advice when working with Excel through an ODBC connection.
What people forget when writing data to an excel sheet is to disable the read-only option during ODBC configuration. Press the options button to get the rest of the screen.
Defining a table
If you want your sheet to behave as a database table, you need to define a table name and indicate the range in your sheet that is applicable to that table. Therefore go to Insert - Name - Define...
In the dialog box you get enter the name of your table and select the range of cells you want in that table.
Defining the columns (Fields)
The first row in the range you selected (table definition) contains the name of the columns of your table. In our example this would be A1, B1 and C1.
Important: make sure your column names do not contain spaces or operators typical to excel (like - = / + $ )
What else goes wrong
PROMES BVBA - Laarsebeekdreef 14 2900 Schoten Belgium
Tel: +32 475 87 69 38 - E-mail: email@example.com