Hi Mike. NDB is a new one on me -- are you sure it isn't NDX (dbase index file) or MDB (Microsoft Access database)?
What programs or software do you use to manage this database? See if there is an Export function -- your best bet is to export the records as a comma- or tab-delimited file.
Failing that, you might try doing a query like this --
select trim(column1)||',' ||trim(column2)||',' ... ||trim(columnN) from theTable
This will produce a result set consisting of only one column that has commas "built in" (use some other character if any of the fields actually contain commas). You can then copy/paste into a text editor (assuming the file isn't too humungous) to create your comma-delimited file, which most target database systems can then import.
For More Information
- What do you think about this answer? E-mail us at editor@searchDatabase.com with your feedback.
- The Best Microsoft SQL Server Web Links: tips, tutorials, scripts, and more.
- The Best SQL Web Links
- Have a SQL tip to offer your fellow DBA's and developers? The best tips submitted will receive a cool prize--submit your tip today!
- Ask your technical SQL questions--or help out your peers by answering them--in our live discussion forums.
- Ask the Experts yourself: Our SQL guru is waiting to answer your technical questions.
This was first published in May 2001