Make table on csv import?

[rforster]

Good Morning,

Have used other database programs and importing was very simple.

Created a blank db and a table called sales. Went to file / import records/ file and selected my csv and clicked open. There was a list of all the field names from row 1 of the csv as I've seen with other programs but the import button was grayed out.

There isn't a way to create a table on the fly and define the fields after?

Consulted help but basically just referred to csv as a valid file to import.

Thanks for any help.

[mr_vodka]

Try:

Import --> File --> (Choose your csv) --> Target --> New Table

[rforster]

Hey Thank. I got thrown by it assigning the table name that I couldn't change.

File --> Import records --> File --> (select file to import) --> Open --> New Table --> Import

Changed the Table name to Sales from Sales200901. Imported Sales200902 to my Sales table. Very nice.

Looking at the table view it doesn't show all the field but List view appears to have everything.

Thanks for your help!