Log in Register FAQ Memberlist Search ContactReview Forum Index
A GoldMine Discussion and Support Community

ContactReview Forum Index » GoldMine 6 » GM 6.7: Getting Excel xlsx/xls converted to dbf for re-impor
Post new topic  Reply to topic View previous topic :: View next topic 
GM 6.7: Getting Excel xlsx/xls converted to dbf for re-impor
PostPosted: Mon Feb 10, 2014 12:34 pm Points: 0 Reply with quote
SugarHooves
n00b
Joined: 06 Apr 2012
Posts: 7




Hi --

Forced to upgrade my Excel 2003 to Excel 2010. Been using Excel 2003 as my export 1000s of records from GM 6.7, certain fields were updated by 3rd party, and then re-save as Excel 2003 dbf to re-import into GM 6.7 using Account# match to update changed fields.

NOW with Excel 2010, no save as dbf format, txt format does not work (do field delimiters). I am at a loss.

How do I re-save a changed dbase in Excel 2010 that is in xlsx format into a dbf format or find a conversion program from xlsx/xls into a GM 6.7 usable dbf format?

Ideas? Suggestions?

Let me know.

Thanks.


John

_________________
John H Hoffmann
View user's profile Send private message AIM Address

PostPosted: Mon Feb 10, 2014 12:55 pm Points: 1 Reply with quote
bgannett
GoldMine Guru
Joined: 07 Sep 2007
Posts: 1820
Location: Pacific NorthWest




Either send it to a friend who can convert or enter "convert xls to dbf" in Google Search. It will show you a lot of options.

_________________
Bob Gannett
253-627-2244
goldsupport@harbornet.com
*** Providing AFFORDABLE GoldMine Supportsince 1990
View user's profile Send private message

PostPosted: Mon Feb 10, 2014 2:04 pm Points: 0 Reply with quote
SugarHooves
n00b
Joined: 06 Apr 2012
Posts: 7




Bob,

Couldn't see the forest for the trees. Thank you for the mental shakeup. I had done the Google/Bing searches to no avail, just confusing and incomplete solutions.

But, 'checking with a friend' was the frontline solution. Actually, a laptop that my daughter had stopped using a couple years ago still had Excel 2003 and wham, bam ... done.

BUT, still remains the frustration of the lack of Google/Bing solutions findable after several hours research. Thank goodness for older PCs wit older software.

Bob, thanks again.

John

_________________
John H Hoffmann
View user's profile Send private message AIM Address

PostPosted: Tue Feb 11, 2014 10:16 am Points: 0 Reply with quote
DougCastell
GoldMine Guru
Joined: 15 Jun 2006
Posts: 1631
Location: Los Angeles, CA




and here you were on the right site all the time: http://www.castellcomputers.com/?p=78

_________________
Doug Castell

GoldMine Sales and Support:
http://www.castellcomputers.com/
office: (310)601-4738
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number

GM 6.7: Getting Excel xlsx/xls converted to dbf for re-impor
  ContactReview Forum Index » GoldMine 6
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
All times are GMT - 7 Hours  
Page 1 of 1  

  
  
 Post new topic  Reply to topic  


Brought to you by Castell Computers, Doug Castell, Admin
RSS Feed
Powered by phpBB © 2001-2004 phpBB Group
Theme created by Vjacheslav Trushkin