Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default export record from excel...

.... into an already DBF database.(record by record)
How to make that?

  #2   Report Post  
Posted to microsoft.public.excel.programming
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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Export Excel tuncating leading zeros while export to excel from da RHBKV Setting up and Configuration of Excel 1 July 15th 09 01:48 PM
Export Single Record to Append to Access Table RMS Excel Discussion (Misc queries) 1 December 9th 08 07:08 PM
Record macro to export xml IoM Excel Programming 7 May 9th 05 09:49 PM
Export Access Record to Specific Cells in Excel Elecdave Excel Discussion (Misc queries) 0 December 29th 04 04:49 PM
Export CSV; first three rows contain record map DW[_3_] Excel Programming 1 November 29th 04 07:18 PM


All times are GMT +1. The time now is 09:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"