Dear Users
I need a access screen where i can copy and paste the data from the site and report should come in excel format. i don want to paste everytime in every column one by one.
below mentioned entry is one entry
Softron Inc.
Address: 1111 abcdedf St.
placename, india
Phone: (905)111-1111
Fax: 905-111-1111
Category: Accountants
everytime it should paste like this and then can download in excel file
please help me out
You will probably get more help if you at least make an attempt yourself. We offer help not finished solutions!
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
You will need to do the following to get what you want:If you are new to Access, you can be lead through these steps by using the Access Wizards to get you started.
- Create a query with the fields in your table that you want to display.
- Create a report with the query above as your record source.
- Now export your report to Excel.
If you strike any issues during this process, post back with your specific problems and we will attempt to help you.
Alan
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks