MTU.Community


Go Back   MTU.Community > Hoster Software > Hoster Help
Reload this Page Transfering Songbook to Excel
FAQ Calendar Search Today's Posts Mark Forums Read

Hoster Help Post Hoster questions, tips and suggestions here.

Reply
 
Thread Tools Display Modes
  #1  
Old March 22nd, 2006, 12:13 PM
flipper flipper is offline
Registered User
  
Join Date: Dec 2002
Location: Portland, Oregon
Posts: 187
Transfering Songbook to Excel
I did a search and could not find any info on this subject that fit.

Is there a way to copy my songbook into MS Excel?

Due to changes to the database in hoster since my original purchase several years ago my songbooks have become really messed up. Mainly due to the integrity of the database with regards to typos, misplaced commas, etc.

I understand that hoster uses acess for the database so it should be possible to transfer the info into excel so I can manipulate the info and make the corrections and pull out my duplicates etc. Then transfer them back into hoster database and rebuild.

What would be the procedure (in laymans terms please) on how to do this.
Reply With Quote
  #2  
Old March 22nd, 2006, 12:21 PM
gduns - with the Lord's Avatar
gduns - with the Lord gduns - with the Lord is offline
Registered User
  
Join Date: Jun 2003
Location: Louisiana
Posts: 2,773
Import it into access first. right now, it is in access 97 format, so it will have to be imported.

then Export it into excel........
Reply With Quote
  #3  
Old March 22nd, 2006, 01:48 PM
nreel nreel is offline
Honor Roll
  
Join Date: Dec 2002
Location: Indy
Posts: 778
Post #1 by Flipper
Quote:
I did a search and could not find any info on this subject that fit.
My SEARCH found this thread: (See Post #6 by nreel)
http://forum.mtu.com/showthread.php?...ighlight=excel
Reply With Quote
  #4  
Old March 22nd, 2006, 03:07 PM
flipper flipper is offline
Registered User
  
Join Date: Dec 2002
Location: Portland, Oregon
Posts: 187
thank you!!

I will give this a try!
Reply With Quote
  #5  
Old March 22nd, 2006, 07:13 PM
PastMember PastMember is offline
Blocked From MTU.Community
  
Join Date: Mar 2001
Location: Farmington, MI
Posts: 153
If you send me your songs.mdb, I will send you back an excel file.

I have written a utility that takes the songs.mdb and converts it (almost instantly) into a .csv file that can be read by Excel.
Reply With Quote
  #6  
Old March 22nd, 2006, 10:17 PM
flipper flipper is offline
Registered User
  
Join Date: Dec 2002
Location: Portland, Oregon
Posts: 187
so how do I send the file to you...pm's and emails are disabled on this forum
Reply With Quote
Reply

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes
Hybrid Mode Hybrid Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is On


All times are GMT -4. The time now is 04:09 AM.

Contact Us - MTU.com website - Archive - Privacy Statement - Top

Powered by vBulletin® Version 3.7.1
Copyright ©2009 - 2025, Jelsoft Enterprises Ltd.
The contents of this forum are copyrighted by Micro Technology Unlimited, 2000-2008. Use of any material from these Forums is prohibited without written agreement from MTU.