![]() |
export record from excel...
.... into an already DBF database.(record by record)
How to make that? |
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? |
All times are GMT +1. The time now is 02:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com