Import from Excel

[skc]

Hi,

I have a table and a form. This form is printed out and
sent to agents.

At the moment, I want to create a special import
procedure, where I can specify which field goes where in
my table for the form to work: e.g. A1=Name, B1=Company
etc....

At the moment I have a table and Form working in Access,
and a separate Excel sheet that I wish to integrate.
These sheets will be appended once a day so the Forms to
be printed.

Please can you give me some pointers.

Thanks,

skc

 

[Marin Kostov]

Open the Tables Object. Right-Click and choose Link Tables. In Files of Type
click Microsoft Excel, and find your XLS file. But before doing this, be
sure to make column headings, i.e. go to the first column first Row in Excel
and write there Name, in the second column Company and etc. In this way you
will design a flat database.
When you click the Link button, follow the instructions and DO NOT FORGET to
check First Row contains Column Headings.
When the table is linked, desing a query with the fields (Columns) you need.