Importing Excell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am attemping to import an excell spread sheet into an
existing defined table. When I go through the import
wizard this option is grayed out and I'm forced to create
a new table. Any suggestions? Thanks in advance.
 
Your Import .xls file needs to contain the Table Header
Info as the First record. It must match the Table Layout
you are importing to. The easiest way to get that info is
to export your current table to a .xls file. If your
table does an auto number that will prob be the first
column called "ID" of your new export .xls file. Delete
that column prior to import.
Copy the first line and paste it into your Import .xls
file as the First line. Make sure all the data lines up
and also make sure the data in the columns match the Data
Type defined in your table. Save the File and You are
ready to Import.
Also you must click the checkbox "First Row Contains
Column Headings" in the Import wizard.

Hope this helps,

Gary
 
Back
Top