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

Does anyone know how to save a file as db4 in the new Excel 2007?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,393
Default database formats

Save as a comma delimited file. You db4 app will read this Ok just as Excel
reads comma delimited files.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"TChristian" wrote in message
...
Does anyone know how to save a file as db4 in the new Excel 2007?



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default database formats

Thanks Bernard,
I am using Visual DBase, when the app tries to open the .csv file it
responds with an error " not a valid dbase table" any suggestions?
Thanks

"Bernard Liengme" wrote:

Save as a comma delimited file. You db4 app will read this Ok just as Excel
reads comma delimited files.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"TChristian" wrote in message
...
Does anyone know how to save a file as db4 in the new Excel 2007?




  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,393
Default database formats

Does this app have a File | Import feature?
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"TChristian" wrote in message
...
Thanks Bernard,
I am using Visual DBase, when the app tries to open the .csv file it
responds with an error " not a valid dbase table" any suggestions?
Thanks

"Bernard Liengme" wrote:

Save as a comma delimited file. You db4 app will read this Ok just as
Excel
reads comma delimited files.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"TChristian" wrote in message
...
Does anyone know how to save a file as db4 in the new Excel 2007?






  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,393
Default database formats

Have a look at
http://www.vicman.net/lib/visual-dbase.htm

--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"TChristian" wrote in message
...
Thanks Bernard,
I am using Visual DBase, when the app tries to open the .csv file it
responds with an error " not a valid dbase table" any suggestions?
Thanks

"Bernard Liengme" wrote:

Save as a comma delimited file. You db4 app will read this Ok just as
Excel
reads comma delimited files.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"TChristian" wrote in message
...
Does anyone know how to save a file as db4 in the new Excel 2007?








  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default database formats

Thanks for your help Bernard.

The app does not have an import feature however, as a workaround I was able
to import the csv file into Access and re-export it out as a db4 file format.
Not sure if this is the best approach but it worked.

If you come across a better solution, plz feel free to send it to me.
Again, thanks for your efforts.

"Bernard Liengme" wrote:

Does this app have a File | Import feature?
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"TChristian" wrote in message
...
Thanks Bernard,
I am using Visual DBase, when the app tries to open the .csv file it
responds with an error " not a valid dbase table" any suggestions?
Thanks

"Bernard Liengme" wrote:

Save as a comma delimited file. You db4 app will read this Ok just as
Excel
reads comma delimited files.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"TChristian" wrote in message
...
Does anyone know how to save a file as db4 in the new Excel 2007?






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
Conditional Formats, how to scroll and view all formats? Bill E Excel Worksheet Functions 0 May 12th 10 07:58 PM
Copying formats - column widths, formats, outlining to worksheets DavidBr318 Excel Worksheet Functions 4 August 14th 09 05:03 AM
Conditional formats- paste special formats? jcarney Excel Discussion (Misc queries) 1 November 1st 07 06:37 PM
Using Excel as a database and need macro or vba to take data entered on one tab and update the database by adding to the next avail row rjr Excel Programming 5 June 11th 06 09:43 PM
Formats: Too many different cell formats error message [email protected] Excel Programming 3 February 1st 05 01:34 AM


All times are GMT +1. The time now is 02:56 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"