If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > PC based Database Applications > Microsoft Excel > Convert Excel2007 database to Works 9.2 database?

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 10-20-09, 20:14
zoobeedo zoobeedo is offline
Registered User
 
Join Date: Oct 2009
Posts: 2
Angry Convert Excel2007 database to Works 9.2 database?

Sorry but I hate Excel. We are trying to convert an Excel 2007 database to a Works 9.2 database. Microsoft has me copying data from Excel into a Works Spreadsheet and then into a Works database. It worked fine, at first. Now that I am halfway thru it it is only allowing me to sometimes copy and paste one date or number at a time. I have 3695 rows with 56 columns. I need this done yesterday. Does anyone know an easier conversion. I tried all the older methods, they don't work, converting to text or CSV file etc. Please help this is driving me nuts and it will take me a month to finish this at this rate.
Reply With Quote
  #2 (permalink)  
Old 10-26-09, 08:48
Colin Legg Colin Legg is offline
Registered User
 
Join Date: Sep 2008
Location: London, UK
Posts: 477
Sounds to me like you should hate Works, not Excel.

I don't have Works, I've never done this and I never want to! (Why do you want to?) It should be a lot easier than this though. There's a MS Help & Support article on how to import an Excel 97 worksheet into a Works database:
Works: How to Import and Export Works Databases to Excel 97

Have a play around with it; hopefully the process is pretty similar with Excel 2007.

Hope that helps...
Reply With Quote
  #3 (permalink)  
Old 10-26-09, 14:34
zoobeedo zoobeedo is offline
Registered User
 
Join Date: Oct 2009
Posts: 2
Converting Excel to Works

Sorry, we do love Works. It's does the best mail outs. Already tried your link. The old methods do not work on the new Excel/Works databases.
Thanks for trying to help
Sue
Reply With Quote
  #4 (permalink)  
Old 10-26-09, 14:59
Colin Legg Colin Legg is offline
Registered User
 
Join Date: Sep 2008
Location: London, UK
Posts: 477
Hi Sue,

Fair enough, sorry I can't offer any more help (I wasn't sure what the "old methods" were) - let us know if you find a good way to get this done.

Good luck!
Colin
Reply With Quote
Reply

Thread Tools
Display Modes

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 Off
Trackbacks are On
Pingbacks are On
Refbacks are On