View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bill Renaud[_2_] Bill Renaud[_2_] is offline
external usenet poster
 
Posts: 117
Default export record from excel...

Export the data from Excel to either a Text (tab delimited) or a CSV
(Comma-Separated-Value) file. Then use normal data import commands in your
database program to import the data. (Maybe your database program can even
import data from an Excel worksheet directly without saving to an
intermediate file format.)

Hopefully, your data in your Excel workbook is in list format. If only some
records need to be exported, then add a column named "Export" at the right
of the data. Set the value to TRUE for each record to be exported, sort all
the records so that these are together, then copy and paste into a new
workbook and save as one of the file formats noted above.
--
Regards,
Bill


wrote in message
ups.com...
... into an already DBF database.(record by record)
How to make that?