Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
export record from excel...
.... into an already DBF database.(record by record)
How to make that? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Export Excel tuncating leading zeros while export to excel from da | Setting up and Configuration of Excel | |||
Export Single Record to Append to Access Table | Excel Discussion (Misc queries) | |||
Record macro to export xml | Excel Programming | |||
Export Access Record to Specific Cells in Excel | Excel Discussion (Misc queries) | |||
Export CSV; first three rows contain record map | Excel Programming |