INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

searc tool for converting excel file to a dbf

searc tool for converting excel file to a dbf

(OP)
Hey
I search for a tool to convert a excel file to a dbf
Anyone a suggestion ?
thanks in advance
Bob

RE: searc tool for converting excel file to a dbf

Hi, Bob

In Excel, file/save as type csv
In xBase create a database with appropriate layout for the columns in Excel, and then import from <filename>.csv delimited.

This will work unless the Excel spreadsheet is not organized in columns and as long as it doesn't have any multi-line text cells. It is best to define all fields in the db as character and then do any numeric/date conversions afterwards.

In general saving as type .dbf out of Excel dnw's, but going via CSV works most of the time.

Jock

RE: searc tool for converting excel file to a dbf

(OP)
Thanks Jock for your advice
I will test it out
Bob

RE: searc tool for converting excel file to a dbf

bobmie,

As usual Jock is right on the money.  I will push from EXCEL to a dbf format whenever possible but there are a number of problems that crop up converting straight out of EXCEL an into a dbf format. But for simple layouts you can come from EXCEL to a dbf format and it is pretty clean.   Sometimes I will run a dbf out and a CSV out, clean out the dbf, and load the CSV into the dbf shell that I just created.  Jock is correct in that the field types are better off as character and then converted as needed when you get into the dbf format.

Jim C.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close