Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



How to save excel file as Database 3

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 08-01-2012
Member
 
Join Date: Dec 2011
Posts: 64
How to save excel file as Database 3

Hi friends, recently I was trying to save my Excel file as Database 3, but however I was not able to create these. I have try various steps and tricks to save my Excel file as Database 3 but fail to do that. I have also visited several of forums and links but still not get the proper solution for this, so if you guys have any of the information then please let me know.
Reply With Quote
  #2  
Old 08-01-2012
Member
 
Join Date: Aug 2011
Posts: 690
Re: How to save excel file as Database 3

According to my information, if you have MS Office Professional, Access will export to Dbase III. Just use Access to get the Excel file and export. I'm not sure how it?ll handle formatting. DBase III had a maximum field name of 10 characters, couldn't contain spaces, etc.
Reply With Quote
  #3  
Old 08-01-2012
Member
 
Join Date: Aug 2011
Posts: 539
Re: How to save excel file as Database 3

Just wanted to let you know that there is the released for the new version of the add-in that enables saving a DBF file in Excel.

The New features:

1. you can add/insert new fields, create calculated fields in addition to adding new records or editing existing records in your
native DBF file!

2. If you start with an Excel file the software now have enhanced capabilities to determine the field types (better than Microsoft's own
in earlier Excel versions).

3. The add-in checks DBase field naming conventions and also identify duplicate fields. All problem field names are visually
identified with a cell comment!

4. If you start out with a brand new file and forget to save it, the add-in will ask before the conversion.

5. Large files are supported. I edited files over 500,000 records with no problem.
Reply With Quote
  #4  
Old 08-01-2012
Member
 
Join Date: Aug 2011
Posts: 578
Re: How to save excel file as Database 3

That was one of the features that were deprecated in Excel. If you have a copy of 2003 and can load the file there, you will have the option to save as a dBase file.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to save excel file as Database 3"
Thread Thread Starter Forum Replies Last Post
How to save excel file as pdf? Imtiyaz Tips & Tweaks 5 27-07-2011 01:41 AM
run Batch-file export in excel (its for a Movie database) rayg Software Development 4 22-12-2010 08:31 PM
File byte array to save in database New ID Software Development 5 21-01-2010 11:22 AM
How to merge an excel file to database? klite Windows Software 3 16-10-2009 11:46 AM
Save an Excel file into PDF with VBA wasim Software Development 4 24-01-2009 11:16 AM


All times are GMT +5.5. The time now is 07:20 AM.