can any one tell me abt how the access table can be updated using
excel file or spead sheet
help regarding MS ACCESS
Hot Topic
- Can't install VS Beta 2
- Crystal report in vb 2005 express
- Copy/Paste
- Help Broken Help Editing Macros in VS 2005 Beta2
- easiest way to pipe data from word doc to database
- Desperate for help - getting my Add-In to run
- How to use the Events of Outlook.Application in COM components?
- Problems creating an office project
- Creating Custom Editor
- Crystal Report External Control with Khmer Unicode Support, but not support with VS 2005
Visual Studio
- Visual Studio 2003 uninstall
- Why text is appended when writing text to bookmarks in a doc?
- Adding a toolbar to a manage tool window VS2005
- "Unable to attach to the process" error when debuging Excel application
- strange thing.. no preview,data and layout pane in report.rdlc
- building solution containing VSTO on CruiseControl.NET?
- No WinFX template in VS2005!?
- Install failure in VS2205 Pro Release version
- iwizard vstemplate
- Using an object as input to the CR Designer and runtime
help regarding MS ACCESS
KarthikNarasimhan
Hello,
Excel files can be imported into Access through File > Import.
Brian
Scav
Kamii,
You can update tables from Excel spreadsheets a number of ways. As already mentioned (assuming you are on Office 2003 here), you can do an XML import, becauses Excel 2003 offers its data through SpreadsheetML. It's a breeze using the Import method.
Now, if you want to do more targeted updates, for example, you want to grab a List or a named range of cells, you can open the spreadsheet programmatically, grab the list or named range, and then access the data in the list or range. You can then use these data to update your table using the standard data operations in Access.
It is helpful to remember that this forum is mainly for issues that directly pertain to the Visual Studio Tools for Office tools per se. So you will be best served by posing this question to a forum or newsgroup wholly dedicated to application-specific issues such as yours. Here is a link to resources that will help you:
Access Developer Portal
You will want to look at the articles, reference material, and appropriate newsgroups there.
Regards, and Rock On
John.