What is a .sdf file? How to generate a .sdf file using ms access?

You can try to use third party Access file recovery program to recover your lost and corrupted data from .mdb files. For more details about this software:-
Access File Recovery Software

The .sdf or standard data file is used for storing data in a structured format; uses fields of fixed lengths to store values; can be imported and exported by various database and data analysis programs; commonly used for transferring data between different programs.

Hi,

There are 2 ways to do it..

Step 1
You can export as text and import it back to excel using the text file you created.
Or
You can select HTML and give the file name as eg-XYZ.xls


Step 2

You can export all reports and statements. For this a separate export button is provided in right hand button bar. To do this go to any report e.g. day book you to export or any statement e.g. balance sheet. You would see export button on top right hand side on button bar. Press it and a screen would pop up with export related options.

The first option is format of data to be exported namely ASCII, HTML, SDF, and XML. Which ever application you are importing this data in would decide in which format you should export the data.
For statements like balance sheets and trial balance which we use to send and import file in word and excel etc. HTML format is good. We need minimum formatting in this format while using it in MS Word and MS Excel.
certain applications accept continuous data where we have defined field length. Then ASCII format is better.
For application which accept SDF and XML format these formats can be chosen.

Give a file name and the exported file is saved in the parent Tally directory on your computer. You can now use that file to import its contents into another program, send it as it is (say if it is HTML file) to a colleague or view it using a browser.

Step 3

Consider exporting day-book.Go to day book press export button or use shot cut key Alt+E. Exporting screen will displayed.



Press Back space on your keyboard. And select Format as ASCII (comma delimited). Now give output File Name as Daybook.csv, now select some other option you want to export from the bottom of the screen.



Press enter to accept screen. Day book is exported in to tally program folder. Check program folder for file daybook.csv,



Double click on it, the file will open in excel program. If you want it in excel work sheet file, use the option Saveas, and save it in Microsoft excel workbook (*.xls) format.



Hope this is helpful. Let us know if the issue is resolved.





*Rating and Comments are invited for this solution

Hi,

There are 2 ways to do it..

Step 1
You can export as text and import it back to excel using the text file you created.
Or
You can select HTML and give the file name as eg-XYZ.xls


Step 2

You can export all reports and statements. For this a separate export button is provided in right hand button bar. To do this go to any report e.g. day book you to export or any statement e.g. balance sheet. You would see export button on top right hand side on button bar. Press it and a screen would pop up with export related options.

The first option is format of data to be exported namely ASCII, HTML, SDF, and XML. Which ever application you are importing this data in would decide in which format you should export the data.
For statements like balance sheets and trial balance which we use to send and import file in word and excel etc. HTML format is good. We need minimum formatting in this format while using it in MS Word and MS Excel.
certain applications accept continuous data where we have defined field length. Then ASCII format is better.
For application which accept SDF and XML format these formats can be chosen.

Give a file name and the exported file is saved in the parent Tally directory on your computer. You can now use that file to import its contents into another program, send it as it is (say if it is HTML file) to a colleague or view it using a browser.

Step 3

Consider exporting day-book.Go to day book press export button or use shot cut key Alt+E. Exporting screen will displayed.

Press Back space on your keyboard. And select Format as ASCII (comma delimited). Now give output File Name as Daybook.csv, now select some other option you want to export from the bottom of the screen.

Press enter to accept screen. Day book is exported in to tally program folder. Check program folder for file daybook.csv,

Double click on it, the file will open in excel program. If you want it in excel work sheet file, use the option Saveas, and save it in Microsoft excel workbook (*.xls) format.

Hope this is helpful. Let us know if the issue is resolved.

*Rating and Comments are invited for this solution

There are some reasons which may damage your MS access database such as virus infection, software crash, accidental shutdown of system, unrecognized format of database, corruption of storage media etc. These issues are easy to overcome by using third party software of access database repair.you can try Kernel Access Database Recovery Software one of the best software in Data Recovery

For information you can visit here ...http://www.accessrecoverytool.net

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.

LDF - layered data file, is the transaction log file for your database. It allows you to roll back changes you made to the data to a particular point and is used in rebuilding the data should it become corrupted.

MDF - Meta data file, is your actual data

SDF - Is a sequential data file, a flat file that can be used for compatibility with MS-SQL server, MySQL, etc.

Sir,

What to Export ?
Tally has a facility to export its data to other applications like spreadsheets, word processing software and other database software. Export of data is provided mainly for summaries and statement reports like Trial Balance, Stock Summary, etc. You can export it to another company using Tally that will import it directly.

How to Export?
You can export all reports and statements. For this a separate export button is provided in right hand button bar. To do this go to any report e.g. day book you to export or any statement e.g. balance sheet. You would see export button on top right hand side on button bar. Press it and a screen would pop up with export related options.

The first option is format of data to be exported namely ASCII, HTML, SDF, and XML. Which ever application you are importing this data in would decide in which format you should export the data.
For statements like balance sheets and trial balance which we use to send and import file in word and excel etc. HTML format is good. We need minimum formatting in this format while using it in MS Word and MS Excel.
certain applications accept continuous data where we have defined field length. Then ASCII format is better.
For application which accept SDF and XML format these formats can be chosen.

Give a file name and the exported file is saved in the parent Tally directory on your computer. You can now use that file to import its contents into another program, send it as it is (say if it is HTML file) to a colleague or view it using a browser.

Thanks
Good Luck

.SDF File Extension (SQL Database File), the filef ormat for Microsoft SQL Server Compact databases.

Please rate this a fixya

Regarding what is .SDF -- A file format that is compliant with the combination of SQL Server 2005 Compact Edition, SQL Server 2005 and Visual Studio 2005 to build, test, deploy, and manage applications for users. Databases of this type can be accessed directly as a datasource, e.g., from Visual Studio 2005, or from SQL Server Management Studio. As such, they can be passed around with programs or projects, although they are mainly used for embedded applications. The file includes all necessary code points to access the data, and so does not require an instance of SQL Server to be installed.

You can create a .SDF file with a software called PocketSYNC. (Although i have never tried it myself, a lot of people claim that this software works like charm. But it is not free)