Re: Import from Excel
From: Marin Kostov (Marin_Kostov_IT_at_hotmail.com)
Date: 04/23/04
- Next message: Bill Taylor: "Re: Numeric Field Overflow Error"
- Previous message: Tony C: "My Switchboard form won't open"
- In reply to: skc: "Import from Excel"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 23 Apr 2004 16:46:00 +0200
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.
-- Marin Kostov Microsoft Office XP Master Instructor
- Next message: Bill Taylor: "Re: Numeric Field Overflow Error"
- Previous message: Tony C: "My Switchboard form won't open"
- In reply to: skc: "Import from Excel"
- Messages sorted by: [ date ] [ thread ]
