Steps in saving file in excel to database

Take a look at this video

To save an Excel document as a .TXT file, follow the steps below:
1. Click on "File" from the Menu Bar 2. Click "Save as" 3. A new window will appear, in the box title "File Name", give the document a name. 4. In the box titled, "Save As Type", click on the drop-down arrow and select "Text (Tab Delimited) (*.txt)" 5. Click "Save"

SDF file is a compact relational database also called a SQL server database. Designed for the application that runs on mobile devices and desktop.
If you only want to access SDF files in Excel sheets then you can see your SDF files in SQL Server or Visual Studio.

The trackball on the BlackBerry smartphone is not functioning.
Complete the following tasks to resolve this issue:

1. Back up the BlackBerry smartphone data. To perform a full backup of the BlackBerry smartphone data complete the following steps:
   
   1. Connect the BlackBerry smartphone to the computer running BlackBerry Desktop Manager.
   2. Open BlackBerry Desktop Manager.
   3. Click Backup and Restore.
   4. Select Backup to perform a full backup.
   5. Select a location to save the backup file, and then click Save.
   To perform a selective backup for one or more databases perform the following steps:
   
   1. Connect the BlackBerry smartphone to the computer running BlackBerry Desktop Manager.
   2. Open BlackBerry Desktop Manager.
   3. Click Backup and Restore.
   4. Click on Advanced.
   5. Select the database(s) on the right side selection window for Device databases.
   6. Select the Arrow that points to the left side of the screen to transfer the database(s) to include in the backup.
   7. Verify the database(s) are on the left side selection window for the Computer databases.
   8. Click on File in the menu located at the top left hand side of the Desktop Manager.
   9. Name the backup file and select a location to save the file.
   10. Click the option to Save once the location for the file is selected.
2. Use the application loader tool to delete all data and applications from the BlackBerry smartphone.
3. Re-install the BlackBerry® Device Software using the application loader tool.

To perform a clean installation of the BlackBerry Device Software using BlackBerry Desktop Manager 4.5 to 5.0, perform the following steps:

Before proceeding, make sure that the latest version of BlackBerry Device Software is installed on the desktop computer by completing the following steps:

1. Open BlackBerry Desktop Manager.
2. Click Help.
3. Select About Desktop Manager.
4. Click the Device Software tab.
5. Verify that the BlackBerry Device Software displayed is the latest version currently available from the wireless service provider.

Warning: The following procedure will delete either all data, or applications on the BlackBerry smartphone. Back up the BlackBerry smartphone data before proceeding.

To perform a full backup of the BlackBerry smartphone data complete the following steps:

1. Connect the BlackBerry smartphone to the computer running BlackBerry Desktop Manager.
2. Open BlackBerry Desktop Manager.
3. Click Backup and Restore.
4. Select Backup to perform a full backup.
5. Select a location to save the backup file, and then click Save.

To perform a selective backup for one or more databases perform the following steps:

1. Connect the BlackBerry smartphone to the computer running BlackBerry Desktop Manager.
2. Open BlackBerry Desktop Manager.
3. Click Backup and Restore.
4. Click on Advanced.
5. Select the database(s) on the right side selection window for Device databases.
6. Select the Arrow that points to the left side of the screen to transfer the database(s) to include in the backup.
7. Verify the database(s) are on the left side selection window for the Computer databases.
8. Click on File in the menu located at the top left hand side of the Desktop Manager.
9. Name the backup file and select a location to save the file.
10. Click the option to Save once the location for the file is selected.

Once you perform backup procedure, kindly then perform the following steps:

1. Connect the BlackBerry smartphone to the computer and open BlackBerry Desktop Manager.
2. Double-click Application Loader.
3. Click Next to start the installation process.
4. Type your BlackBerry smartphone password, if prompted, and click OK.
5. Select the check boxes next to the names of the applications to be loaded, and then click Next.
6. Click Settings, and then select the check boxes beside Delete all application data and Erase all currently installed applications.
7. Clear the check box next to Backup up device data automatically during the installation process.

Click Ok > Next > Finish.

When the process has completed, the message The loading operation was successful will appear. Click Close to return to BlackBerry Desktop Manager.

To perform a clean installation of the BlackBerry Device Software using BlackBerry Desktop Manager 4.1 to 4.3, complete the steps 1-5 above and then proceed with the following:

1. Click Advanced , and then select the check boxes beside Erase all application data and Erase all currently installed applications
2. Click Next.
3. Select the check box next to Do not automatically backup the application data during the loading process (if prompted).
4. Clear the check box next to Backup and restore applications installed wirelessly (if prompted).
5. Click Next > Finish.

In this case you need to follow certain steps given below:-

To perform a full backup of the BlackBerry smartphone data complete the following steps:

1. Connect the BlackBerry smartphone to the computer running BlackBerry Desktop Manager.
2. Open BlackBerry Desktop Manager.
3. Click Backup and Restore.
4. Select Backup to perform a full backup.
5. Select a location to save the backup file, and then click Save.

To perform a selective backup for one or more databases perform the following steps:

1. Connect the BlackBerry smartphone to the computer running BlackBerry Desktop Manager.
2. Open BlackBerry Desktop Manager.
3. Click Backup and Restore.
4. Click on Advanced.
5. Select the database on the right side selection window for Device databases.
6. Select the Arrow that points to the left side of the screen to transfer the database to include in the backup.
7. Verify the database are on the left side selection window for the Computer databases.
8. Click on File in the menu located at the top left hand side of the Desktop Manager.
9. Name the backup file and select a location to save the file.
10. Click the option to Save once the location for the file is selected.

To Download the Blackberry Device Software follow the steps:-

1) Click the BlackBerry Device and Desktop Software link.
2) Click the Download BlackBerry Device and Desktop Software link.
3) Select the appropriate software from the drop-down list and click Next.
4) Click the Download link.
Please verify with your service provider before downloading any of this software to make sure it is compatible with your BlackBerry Device Software.


To delete all data from the BlackBerry smartphone, complete the following steps:

Lock the BlackBerry smartphone, and then type an incorrect password ten times.If prompted, type blackberry. Once complete, all data on the BlackBerry smartphone is deleted.

Still if it is not working it might be a Hardware issue you need to contact your service provider for further details.

Thank you for using Fixya.

More information is required so I will only assume you are using Excel as a database. Excel is a spread sheet program used by accountants or for mathematical formulas and ledgers. Access is the Database program, however, Excel has functions which is faster to sort and work with address, phone number, zip codes. I will confess, I use Excel as Database because it is quick and easy. I do not know what version of Excel you are using so I will describe it from Office 2007. From Excel make sure you have headers above each column i.e. First Name in Cell A1 Last Name in Cell B1 Address in Cell C1 ect.

Make sure your data is correct and case sensitive as you would like it. If you want zip+4 select the Colum and right click to format the cells using special and select Zip or Zip+4.
It is easiest to use Microsoft Word for the next step rather than format the cells, add page breaks, and customize the print size.
Save your document as an Excel document where you can find it to import it into Word.
Open word and select Mailings then Start Mail Merge and Step by Step Mail Merge.
Select Envelope and next. Select envelope options to change envelope size, font and print options.
Click on Next Select recipients.
Click on browse under select an existing list.
Select the Excel file with your address information.
From the Select Table check the First row of data contains column headers.
Click on the OK buton.
Arrange your envelope then Preview it and your good to go.
If you have an older version of word selects Tools and click on Mail Merge.
Select Get Data.
Pull down Excel for document type.
Select entire Spread Sheet.
Layout your document and complete the merge.
On old versions of word it may not recognize the Excel file. If this happens open the Excel file and save it as a Database File (.dbf) and it should work.
I hope this helps since I did not have enough information from your question.

This problem may occur if a noncontiguous selection is included in any one of the following: • Sheet selection • AutoFilter • Publishing Excel data to a Web page • Conditional formatting • Pivot Table reference • Pivot Table area • Pivot Table location • Unknown XML

it that does not work then goto control panel and reinstall office

From the Microsoft Office 2003 Web site:

Excel 2000 or later versions cannot directly open files created in Microsoft Works version 3.0 or later. To open a Works file in Excel, first open it in Works and use the Save As command to convert it to one of the file formats listed below. Then close the Works file and open the converted version in Excel.

• Works for Windows 2.0/Works for DOS SS
• Excel SS
• Lotus 1-2-3

To open a Microsoft Works database file in Excel, first save the file in Microsoft Works as a dBASE file, and then open the dBASE file in Excel.