The main thing to do is create a blank database with the exact names of the columns from the excel file as separate fields in the database. Save the Excel file as a comma delimited CSV file, Copy it to your BN. Then, use the database import function, or whatever they call it, to bring the contents into the database. It will ask you the questions like does the first line contain field names, etc. It does a reasonably good job of matching up the fields if you named them correctly. Or, you can correct the matches in the process.
The thing to note is that you cannot do any calculations within the BN database, it just holds and sorts the data. Richard -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Stephen Sent: Sunday, February 08, 2009 11:32 AM To: Sharon S; [email protected] Subject: re: [Braillenote] XL Documents Hi Shaz, and Anne, You should be able to save the XL as a CSV "Comma Separated Values" file. This is the file that you could then import to a database on the BN. I don't know how well this works, for although I did get a CSV file from XL, it didn't have anything like the number of double quotes to delimit fields as a CSV file from a database on the BN. So there might be two problems. 1. If tbe BN is very fussy about the double quotes around field values in CSV files, it might not import the data that well. 2. It would help if there is a way of getting XL to tell you what format each column is in. If not we could still try to make a reasonable stab at a database. I am willing to try and help with databases if I can. Regards, Steve. > ----- Original Message ----- >From: Sharon S <[email protected] >To: [email protected] >Date sent: Sat, 07 Feb 2009 09:40:34 +1100 >Subject: re: [Braillenote] XL Documents >Hi, there is a way to read excel files but it is not quick or easy. >You have to set up a database on the braillenote with the same fields >as the excel document then you export the excel document on a pc to a >format, sorry I can't remember what it is called at the moment, then >you take that file and import it into your database on the braillenote. >You have to do the same thing each time you want to read an excel >document on your braillenote unless each time the document is set out >exactly the same. I keep meaning to do this for some excel files I get >each month for a committee I am on but I haven't had the time and I'm >not all that confident on setting up databases. If I can do it then it >will help both me and another friend on the committee who also uses a >braillenote. >Good luck with your new machine and I'm sure if you really want to set >up a database for your excel document there will be someone on this >list that knows what they are doing that can help you. >>From Shaz. >Bn Qt MPower and Pk user. >>----- Original Message ----- >>From: "Anne Cosgrove" <[email protected] >>To: <[email protected] >>Date sent: Fri, 6 Feb 2009 22:13:39 -0000 >>Subject: [Braillenote] XL Documents >>Hi List >>I'm hopefully going to be getting a BN Mpower in the next couple >of weeks >>and I was just wondering if it's possible to transfer an XL >document to the >>BN? >>Regards >>Anne in Northern Ireland >>No virus found in this outgoing message. >>Checked by AVG - www.avg.com >>Version: 8.0.233 / Virus Database: 270.10.18/1937 - Release Date: >02/06/09 >>11:31:00 >>___ >>Replies to this message will go directly to the sender. >>If your reply would be useful to the list, please send a copy to the >>list as well. >>To leave the BrailleNote list, send a blank message to >>[email protected] >>To view the list archives or change your preferences, visit >>http://list.humanware.com/mailman/listinfo/braillenote >___ >Replies to this message will go directly to the sender. >If your reply would be useful to the list, please send a copy to the >list as well. >To leave the BrailleNote list, send a blank message to >[email protected] >To view the list archives or change your preferences, visit >http://list.humanware.com/mailman/listinfo/braillenote ___ Replies to this message will go directly to the sender. If your reply would be useful to the list, please send a copy to the list as well. To leave the BrailleNote list, send a blank message to [email protected] To view the list archives or change your preferences, visit http://list.humanware.com/mailman/listinfo/braillenote ___ Replies to this message will go directly to the sender. If your reply would be useful to the list, please send a copy to the list as well. To leave the BrailleNote list, send a blank message to [email protected] To view the list archives or change your preferences, visit http://list.humanware.com/mailman/listinfo/braillenote
