Wednesday, December 2, 2009

Export Access table data to Excel

Export Access table data to Excel

Sometimes as part of programming you may need to export data from MS-Access to microsoft excel for that follow the simple steps below

1. Right click on the access table

2. Choose Export.

3. Save file dialog will appear

4. In that choose file type as excel and give filename

Export Arabic Data To Excel

If theire is any arabic of any other language data is in the access table then the

data exported will show as "??????????????" for that the best possible way is

1. Open the access table

2. Scroll down to the bottom

3. Click on the "*" below by pressing shift

4. Right click and select copy

4. Open a blank excel file

5. Paste the contents



No comments:

Post a Comment