convert large excel 2010 spreadsheet to dBase

I need to convert a large (1450 column) excel 2010 spreadsheet to any version of dBase. Only Excel 2010 can handle that many columns.Is there a method of direct conversion? Can I do it using other software? It seems that Microsoft took out the dBase conversion facility.Any help appreciated.Does anyone know the size limits of a current dBase iteration?
mzimermanAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

aikimarkCommented:
You are probably going to have to do some data normalization before you can create a dBase file with that, because of the 1450 columns' worth of data.

Why dBase and not some other format?
0
andrewssd3Commented:
I don't remember much dBase, but could it not import a csv or similar text format file if you saved the Excel file as csv first?
0
mzimermanAuthor Commented:
I already have dBase Plus 2.6. What products would you suggest?
0
The 7 Worst Nightmares of a Sysadmin

Fear not! To defend your business’ IT systems we’re going to shine a light on the seven most sinister terrors that haunt sysadmins. That way you can be sure there’s nothing in your stack waiting to go bump in the night.

pcelbaCommented:
You may read the Excel file via ODBC driver directly from dBase. Code which allows it from Visual FoxPro is here: http://www.sweetpotatosoftware.com/spsblog/2008/09/30/UsingExcel2007FileFormatsInVFP90.aspx

You may try it in VFP or rewrite it to dBase. VFP can create dBase compatible files but forget 1450 columns - you have to split the sheet into several vertical parts.

The ODBC driver for Excel 2010 is here: http://www.microsoft.com/download/en/details.aspx?id=13255

And remember if you are using 32 bit dBase you have to install 32 bit drivers.
0
Neil RussellTechnical Development LeadCommented:
What is it you want to achieve in dbase that you cant in excel?
Do you not have the full office suite including MS Access?
0
Neil RussellTechnical Development LeadCommented:
P.S.
If your data is 1450 "Fields" wide I would look at your data very carefully before storing it anywhere!!!
0
mzimermanAuthor Commented:
I've discovered that dBase Plus (even the brand new 2.70) cannot accomodate the filesize (has enough fields but has a 4000 character word limit. Now trying Filemaker 11.01 which should be able to handle filesize and wordsize, but when I try to import, only imports first 66 fields, When I look at Filemaker's one-record at a time view I can see the full record and as a continuous view list I can see the full record.However as a full record view can see only 66 fields.This is the case when importing from a CSV file or from Excel 2010 itself (which shows all of the fields correctly.
I do not use access or Excel for my project because I am not that familiar with how to program them and don't feel that comfortable to attempt a long project programming scripts for them. Any help or comments appreciated. Since the geography of the question has changed should the question remain in this forum?
0
pcelbaCommented:
Does your answer mean the sheet split into several vertical parts cannot apply in your case? Why?

It should work in any above mentioned product.
0
Neil RussellTechnical Development LeadCommented:
Your understanding of relational databases is obviously very limited. To think that you need to transfer all that data into a single table makes that clear.

As i asked earlier, what is it you are trying to achieve? Maybe that will lead us to your correct answer.

Knowing how to use one application does not make it the correct application for any given task. I know how to use a hammer but it plays havoc with my screws still!!
0
pcelbaCommented:
What is better way of normalization? 1) To port all data into an environment which allows this normalization (dBase, Filemaker, FoxPro, ...) or 2) To normalize data in Excel and then to work with these normalised data in Excel or port them afterwards?

I am still voting for option No. 1 and I believe mzimerman also plans this way of data processing.

BUT mzimerman asked for data conversion not any additional hints how to make his data better etc. thus I would reduce and focuss my comments to the question core.
0
mzimermanAuthor Commented:
I need to be able to see the data in one flat file presented as in the excel spreadsheet I have created. I do not wish to have multiple related tables.
0
pcelbaCommented:
Hmm... You have been asking for conversion from Excel to dBase but dBase cannot handle one file with your Excel sheet parameters... The only solution was to split the sheet.

Now you are asking for something different and dBase seems to be unusable for your needs... I have to agree Excel is the tool which will fullfil all your needs but you are "not that familiar with how to program them"...

So you should probably tell what help do you expect from us? And we will say "The best you can do is to pay some consultant or programmer which will do it for you".

You may also use Excel Automation but, again, it will need to study something new, e.g. http://www.hentzenwerke.com/catalog/autofox.htm... (I suppose dBase allows Excel automation.
.)

BTW, both dBase and FoxPro allows to create the 1:1 relation among several tables and you may display them as one flat file but you'll probably find another limitation why this is not achievable and I have to say it again "Use Excel to display one large flat sheet".
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mzimermanAuthor Commented:
It appears that the data is there, only not viewable yet in table view.How can I see the whole table? Or is this a limitation of Filemaker's table view?
0
pcelbaCommented:
You've switched the subject of the question from dBase file to FileMaker. I would recommend to ask this question in appropriate FileMaker EE zone: http://www.experts-exchange.com/Programming/Database/Filemaker_Pro/
0
mzimermanAuthor Commented:
Filemaker is not capable of a larger table view size. Please close this question.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.