hi everyone! someone can guide me how to write data in access database from excel sheet. I want to feed data in excel and save it in access data base automatically. Please help me.
hi everyone! someone can guide me how to write data in access database from excel sheet. I want to feed data in excel and save it in access data base automatically. Please help me.
Build a normalized table in Excel. In Access, instead of importing the table, link the table. Use the Access Import Wizard if you are unsure how to do this.
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
Thanks Alan! its working but the problem is I am unable to use it to another excel file. I want to get this data used in other excel sheet. please help me. I have more question to ask but firstly I like to know about your permission because I don't want you to be teased or nag. Thanks again.
use a macro...command TransferSpreadsheet to bring in the XL sheet.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks