0
Tell you the vba scripting code to fetch datas from Microsoft Excel document and save it into ms access db?
Wiki User
∙ 15y ago
That will depend on the structure of your data. Another method would be to do a Save As in Excel into a neutral format and import it into Access. If you lay the data out in a structured manner, it can be easier to import. You can also create a linked table in Access to reflect any changes. It is also possible to do a lot of database operations directly in Excel, meaning it might not even be necessary to import it into Access. It depends on what exactly you want to do. All this takes a bit more work than that, without having your actual data here to check it and know exactly what you want to do which would help to give more specific advice, but it can be done in several ways, depending on your actual requirements.
Wiki User
∙ 15y ago
Add your answer:
Earn +20 pts
How do you delete the shared document in Microsoft Excel?
I am not sure what you mean by shared document. If you are talking about a document on SharePoint, ensure you have edit access and follow the procedures established on your SharePoint portal for deleting a document.
How far does Microsoft Excel document go?
The answer for the limit of excel is XFD1048576
Is Microsoft Excel the database software of the Microsoft office suite?
No. Excel is a spreadsheet. Access is the database.
What is xls file format?
A document that is created by Microsoft Excel. Excel is a spreadsheet maker.
Which softwares are required for hotel?
Microsoft access+Microsoft word+Microsoft excel
How is the document panel displayed in Microsoft Excel?
To display the document panel in Microsoft Excel click the Menus tab, then click the file drop down menu, and there you will find the View Document Properties link.
What is a correct way to gain access to Microsoft Excel?
You have to buy it. Go to the Microsoft website and download it from there.
How do you freeze a line in a document on Microsoft Excel?
this my personal file
When you open a Microsoft Excel workbook you will see a document or a blank sheet of paper?
What you will see is a blank worksheet, which is a spreadsheet document in Excel.
What is a Workbook on ms Excel?
A workbook, in Microsoft Excel, is what they call the spreadsheet(s). Just as in Microsoft Word, the page you are writing is called the document.
What has the author Sandra Cable written?
Sandra Cable has written: 'Microsoft Excel 7 for Windows 95' 'Excel 5.0 for Windows' 'Microsoft Excel for Windows Tutorial and Applications' 'Teach Yourself Access 97 Visually Student Workbook (Read Less, Learn More)' 'Microsoft Excel 7.0 for Windows 95' -- subject(s): Business, Computer programs, Electronic spreadsheets, Microsoft Excel (Computer file) 'Microsoft Excel for Windows 95' -- subject(s): Business, Computer programs, Electronic spreadsheets, Microsoft Excel (Computer file) 'Microsoft Access 97 for Windows' -- subject(s): Database management, Microsoft Access, Microsoft Windows (Computer file) 'Succeeding in business with Microsoft Office Access 2007' -- subject(s): Business, Computer programs, Database management, Microsoft Access
What is a document or file in which information is permanently stored in Microsoft Excel?
A workbook.
