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



HAPPY PROGRAMMING

PRAISE THE LORD

No comments:

Post a Comment