Importing data from Exel?

[ctuna02]

Is there any way to add a column/field to and existing table then import data into it? Or must you always import an entire record. I realize it is possibe to export and modify in excel then reimport it.

 

[Jediphase]

You can right click on the main database window

select import

Then select the file format for import

IF its an excel spreadsheet then select the RANGE within the spreadsheet i.e. one row..

Then click next and set it up to import to existing table. (the one with the new column) then import away it should append the column data to the table..

Any probs after you have tried as hard as you can let me know..

C

 

[ctuna02]

The trouble is if you append only a column it wants to put the column in a fresh set of records. That is if you want to add 5 records in a column to a new field in the first 5 records( 1 to 5 ) instead the column appears to generate 5 more records( 6 to 10 ) with just that column in it

 

[neileg]

It's not clear what you want to do. Perhaps you are adding a field and then updating the existing records with data in this new field. If this is so, investigate the use of an update query to do this.

 

[ctuna02]

Thanks for your help . I managed to get the stuff in I wanted but
I still have some stuff to learn about the best ways to do this. Also it seems that if the rest of the Excel sheet isn't clean it doesn't like it. My solution was to move only the stuff I wanted into a separte sheet with that alone in it.