need some serious computer help - CSV files | General Arranger Keyboard Forum

You are not logged in. [Log In] Synth Zone » Forums » The Arranger Keyboard Forums » General Arranger Keyboard Forum » need some serious computer help - CSV files

Page 1 of 2

Topic Options

#437325 - 09/11/17 09:00 PM need some serious computer help - CSV files
Mark79100 Senior Member Registered: 10/23/06 Posts: 1661 Loc: USA	I've been collecting music related data ever since my Apple II so you can imagine how much data I have in various databases and text documents. I'm using XP Pro and MS Works for the last 15 or so years. I've been aware for awhile now that if any of my hardware goes down or the OP system crashes, I'm not going to have access to important info. All data files are saved as .WDB .WPS .DOC (but 2004 version). I did some research and read that if I can save my files as .CSV, then Access or Excel can open them up so I can save them in this more permanent format. One problem so far is that some of them are so big, the text gets truncated if I save as a .CSV (I lose data on the really big files). The other problem is there are just too many files to convert (about 1400). I bought a laptop with Windows 10 on it. I can purchase the Access or Excel now but I can’t get clear answers on the following: a) which of the two MS programs will open up the .CSV files and then convert them to the newer format? b) will I lose data in the conversion c) where else can I go to explore this situation Would you believe I went to two Microsoft stores in my area and NONE of the personnel knew what to do. They didn’t even know how to operate Access OR Excel. Figures……they were all kids, and busy playing on their smart phones. Ask them anything else and they’re dumbfounded. When I called Microsoft I got people in foreign countries who could hardly speak English and didn’t even know the products. Their answers were guesses. Anyone have any suggestions? Maybe I’m missing something simple? Anyone see a way of saving this info when the inevitable crash finally happens? Mark
Top

#437329 - 09/11/17 09:42 PM Re: need some serious computer help - CSV files [Re: Mark79100]
DonM Senior Member Registered: 06/25/99 Posts: 16735 Loc: Benton, LA, USA	I'm pretty sure you could open the file in MS Works, then SAVE AS Rich Text file. Then open it in Word and save as Doc. I believe Word has a Works-to-Word converter. _________________________ DonM
Top

#437334 - 09/11/17 10:40 PM Re: need some serious computer help - CSV files [Re: Mark79100]
Mark79100 Senior Member Registered: 10/23/06 Posts: 1661 Loc: USA	Don....yes......I've been saving as many .WPS text documents as I could in both .DOC and .TXT files. Those are the easy ones. It's the databases that I'm having trouble saving in another format. Some of my databases are as large as 15 MB. Woe is me! Did you escape the storm? Did you escape the storm but your keyboards floated away? None of the above. I'm concerned about Bruno....he lives in Florida.
Top

#437337 - 09/12/17 02:42 AM Re: need some serious computer help - CSV files [Re: Mark79100]
Bernie9 Senior Member Registered: 09/21/02 Posts: 5521 Loc: Port Charlotte,FL,USA	I am in Port Charlotte(SWF). We arrived back home yesterday PM and found, AMAZINGLY, no damage, _________________________ pa4X 76 ,SX900, Audya 76,Yamaha S970 , vArranger, Hammond SK1, Ketron SD40, Centerpoint Space Station, Bose compact
Top

#437346 - 09/12/17 06:52 AM Re: need some serious computer help - CSV files [Re: Mark79100]
abacus Senior Member Registered: 07/21/05 Posts: 5408 Loc: English Riviera, UK	Originally Posted By Mark79100 I've been collecting music related data ever since my Apple II so you can imagine how much data I have in various databases and text documents. I'm using XP Pro and MS Works for the last 15 or so years. I've been aware for awhile now that if any of my hardware goes down or the OP system crashes, I'm not going to have access to important info. All data files are saved as .WDB .WPS .DOC (but 2004 version). I did some research and read that if I can save my files as .CSV, then Access or Excel can open them up so I can save them in this more permanent format. One problem so far is that some of them are so big, the text gets truncated if I save as a .CSV (I lose data on the really big files). The other problem is there are just too many files to convert (about 1400). I bought a laptop with Windows 10 on it. I can purchase the Access or Excel now but I can’t get clear answers on the following: a) which of the two MS programs will open up the .CSV files and then convert them to the newer format? b) will I lose data in the conversion c) where else can I go to explore this situation Would you believe I went to two Microsoft stores in my area and NONE of the personnel knew what to do. They didn’t even know how to operate Access OR Excel. Figures……they were all kids, and busy playing on their smart phones. Ask them anything else and they’re dumbfounded. When I called Microsoft I got people in foreign countries who could hardly speak English and didn’t even know the products. Their answers were guesses. Anyone have any suggestions? Maybe I’m missing something simple? Anyone see a way of saving this info when the inevitable crash finally happens? Mark Word will open DOC files as far back as 1997. WDB: If you can export your database in a .DBF Format then Access should open it natively, (As should the free Open Office program) if not follow this link https://support.microsoft.com/en-gb/help...s-2000-database WPS: can be opened in Word or Publisher. CSV files can be opened in Excel Hope this helps Bill _________________________ English Riviera: Live entertainment, Real Ale, Great Scenery, Great Beaches, why would anyone want to live anywhere else (I�m definitely staying put).
Top

#437348 - 09/12/17 07:13 AM Re: need some serious computer help - CSV files [Re: Mark79100]
Gunnar Jonny Senior Member Registered: 04/01/01 Posts: 4400 Loc: Norway	There is several very good alternatives to MS Office at no cost. I.e. Libre Office ( http://www.libreoffice.org/ ) It's a full Office pack, and will handle most of the fileformats. Just remember to set it to handle files as MS Office files during install, or in options afterwards. Then it will save all files as if you did it in Word, Excel etc. _________________________ Cheers 🥂 GJ _______________________________________________ "Success is not counted by how high you have climbed but by how many you brought with you." (Wil Rose)
Top

#437880 - 09/24/17 11:10 PM Re: need some serious computer help - CSV files [Re: abacus]
Mark79100 Senior Member Registered: 10/23/06 Posts: 1661 Loc: USA	Bill……..I finally made it to a MicroSoft store. Again, no help at all. Would you believe they don’t have Access installed on any of their computers. And even then they don’t know how to work it anyway! But…….I had a CSV file on my flash drive. I imported it and opened it up (on their computer) in Excel. All the data showed up in “fields” but they didn’t know how to make a database out of it. As for the Works…..yes. I opened a half dozen Works files in the latest WORD program. No trouble there, at least. The problem with saving as DBF is not all the data gets saved. It has huge dropouts of date here, there and everywhere. Thanks for the “link” but they’re talking about saving as DBF and not CSV. Do you, by any chance, run Excel and if you do, can I post to you a CSV that I converted and see if you can open it up and save it as a database. I don’t know how Microsoft ever got so big with the poor service they have to their customers. All you ever get now is a foreign country with limited knowledge “specialists (?).
Top

#437881 - 09/24/17 11:17 PM Re: need some serious computer help - CSV files [Re: Gunnar Jonny]
Mark79100 Senior Member Registered: 10/23/06 Posts: 1661 Loc: USA	Originally Posted By Gunnar Jonny There is several very good alternatives to MS Office at no cost. I.e. Libre Office ( http://www.libreoffice.org/ ) It's a full Office pack, and will handle most of the fileformats. Just remember to set it to handle files as MS Office files during install, or in options afterwards. Then it will save all files as if you did it in Word, Excel etc. Yes, I remember seeing "libroffice" somewhere on the Net. But doesn't it save in a proprietary format? Or....does it save in a format that Microsoft products can open up? I don't want to go through this again....not realizing that the format I'm saving my databases in will someday cease to exist.
Top

#437886 - 09/24/17 11:58 PM Re: need some serious computer help - CSV files [Re: Mark79100]
DonM Senior Member Registered: 06/25/99 Posts: 16735 Loc: Benton, LA, USA	Libre Office reads and writes all MS formats. I have used it and its predecessor for years. It is an open format, and evolved from Open Office. _________________________ DonM
Top

#437888 - 09/25/17 12:16 AM Re: need some serious computer help - CSV files [Re: DonM]
Mark79100 Senior Member Registered: 10/23/06 Posts: 1661 Loc: USA	Originally Posted By DonM Libre Office reads and writes all MS formats. I have used it and its predecessor for years. It is an open format, and evolved from Open Office. So then, Don, can it import the data in a CSV file and make a database out of it? And.....what is the file extension it saves the database in? Meantime, I'll go over it again on the website and see what I can glean.
Top

Page 1 of 2

Previous Topic

Index

Next Topic

Hop To:

Moderator: Admin, Diki, Kerry

Help keep Synth Zone Online