 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Importing / Linking / June 2004Export to DBase dbf
I am trying to convert an excel spreadsheet into a dbf format. When I tried this from excel (using Save AS), I found that field contents and headers were being truncated, so instead I have imported the spreadsheet into an Access database. Whenever I try to export to dbase I receive an error 'Field will not fit in record'. Any ideas would be gratefully appreciated! Paul > I am trying to convert an excel spreadsheet into a dbf > format. > > When I tried this from excel (using Save AS), I found that > field contents and headers were being truncated,..... Hi Paul, I do this procedure from time to time. It's important to widen all the columns first so that they're sized to the maximum size of the data.  SignatureCindy Winegarden MCSD, Microsoft Visual FoxPro MVP cindy.winegarden@mvps.org www.cindywinegarden.com Thanks for the suggestion - but no luck I am afraid. I used AutoFit to widen the columns, but got the same resul. Once I have 'Saved As' the data appears ok - but if I close and then reopen the created DBF file, one column seems to be truncated to 22chars and another to 43! (the other columns are only 3-8 chars in length and are all ok). >-----Original Message----- >> I am trying to convert an excel spreadsheet into a dbf [quoted text clipped - 7 lines] >I do this procedure from time to time. It's important to widen all the >columns first so that they're sized to the maximum size of the data. > Thanks for the suggestion - but no luck I am afraid. I've found that saving to a CSV file and importing into FoxPro is the most foolproof way to import data, however, you have to make sure the numerical fields aren't formatted with commas for the hundreds. SignatureCindy Winegarden MCSD, Microsoft Visual FoxPro MVP cindy.winegarden@mvps.org www.cindywinegarden.com |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.