i want to integrate microsoft excel with access using visual basic code help?
93524
You can import the Excel spreadsheet into an Access table using the DoCmd.TransferSpreadsheet function.  Once the spreadsheet is in an Access Table, you can either run an update query (using DoCmd.RunSQL) or if you need something more complicated you'll have to open the table and process it row by row.
299182
vc++ is much more tougher to handle than it's compatriot : visual basic. As the saying goes: "vb is fun, vc++ is shit hard work!!".\n\nok..\ni'll give u da steps to create 2 edit boxes and to get the sum : )\n\nhere we go:\n\n1) open ms vc++\n2) go to file ->new and under the projects tab, select mfcappwizard (exe) , enter name and choose location to save project\n3) now, the wizard pops up.\nStep 1 : select dialog based  (since the addition thing is fairly simple, we'll go for this)\n4) press next for step 2 and once again for step 3 (which means u r accepting the default values in those steps).\n\nFinally, u get a dialog showing the summary of the application.\n\nif u have come till here..gooood!! u have created a "skeletal application" .. and this, buddy , is the true essence of MFC programming.\n\nok.. now that u have created the skeleton application , its time i teach u how to put two text boxes and if ya click a button, the sum would be displayed in another :::\n\n\n\n\n* now, on ur left, u should see a "workspace" window. its one containing a list of files in your application.\n\n* in that, select the resources tab (tab is found at bottom of workspace window)\n\n* open the tree listing. in that u would find a "dialog" sub tree\n\n* open that. and u would find a "IDD_..." thing . double click on that, and presto, u would get a blank dialog.\n\n* now, that blank dialog would be accompanied by a toolbox if u dont see the toolbox, right click on the toolbar on top of vc++ window, choose toolbox.\n\n* if u see the toolbox, good. now, choose the edit box (text box) and draw three text boxes on the dialog. now, choose the button and draw one button on the dialog.\n\n* the text boxes would have the name IDC_EDIT1 , IDC_EDIT2 and IDC_EDIT3 and button would be IDC_BUTTON1(u can see the names by right-clickin on the component and choosing properties.)\n\n* ok, now , go to view- > class wizard (a very very very important tool in vc++)\n\n* move to "member variables" tab. u can see the components that u have added.( if u have not, just try flickering with the drop down dialogs that u see there). \n\n* now, double click on IDC_EDIT1 and another small window appears , asking u the variable name it would ve already displayed "m_" DONOT remove the "m_" jus add something to it like : "m_number1" . repeat same for the other two edit boxes and make sure u remember the variable names.\n\n* u have come till here?? awesome!! ; )\n\n* now close the class wizard window.\n* double click on tha button and.. u get a prompt something like onbuttonclick (somethin like dat) ..whatever comes, press ok. and presto, u go into the coding wonderland.\n\n* remember the varible names ?? goood. and u kno how to put an addition statement?? awesome!! . jus do that.. eg: m_number3=m_number1+m_number2;\n\n*CAUTION : while giving variable names , make sure u <<CHOOSE THE int TYPE>>\n\n* phew.. take a break and come back cos u r gonna watch ur creation come to life ; )\n\n*goto project->build xyz.exe\n\n* wait till it completes compilation and shows the sweet words "0 errors 0 warnings" on the bottom window of the screen (watch window).\n\n* press ctrl+f5 and voila.. u get ur own summing application created using MFC and with help of appwizard,classwizard and moi, ANAND ; )\n\n\n\n\nIF u have encountered any problem anywhere enroute to success, worry - not. Send me a message Y! id: anand_87123\ny! mail : anand_87123@yahoo.com\nput the subject line as vc++ - Y! answer\n\nok??\n\nP.S : if ya feel i have helped ya, i dont mind my answer being voted as the best answer by u!!\n\nand also, i can prescribe 2 books for ya :\n1) MFC programming by JEFF PROSISE and \n2) David J Kruglinski, Scott Wingo :: "Programming Microsoft Vc++ Fifth edition"\n\nthey are available for download from da net (illegal ofcourse ... ; ) ) try searching
421773
MS access will do that, \n\nlookfor help in excel for JET or OBDC
292988
Depends on the file that needs to be imported, and how you need to import it.  Enterprise manger comes with an import wizard that you can use to import information.  sometimes it's easier to just import the whole thing and delete what you don't need/want.\n\nanother way would be to make the file into a CVS and import that into access, then by using a linked table, export the table to SQL.
1182532
Ok, if I am understanding this properly, access is referring to Microsoft Access?\n\nYou cannot open a dbf file from within Access.
632591
It really depends upon what you need. I would think that you should be able to buy a software package (which may or may not use Microsoft Access) for your needs. I don't really know exact prices, but I would expect from $20 to $300, you could find something. \n\nIf you are willing to use open source software, the following link contains a list. Some of these may be free, others may charge a licensing fee. Generally, they are less expensive than buying a package from a retailer.\n\nhttp://dmoz.org/Computers/Software/Industry-Specific/Real_Estate/Property_Management/\n\nIf you find that there is no software available which meets  your needs, a good Access programmer is going to cost you at least $30/hour and easily $100/hr. Just for the programmer to figure out what exactly you need is going to cost you $150 to $200.  \n\nUnless you have special needs, it will probably be better to buy a package and modify your office rather than get specialized, one-of-a-kind software. The home-grown option may provide you more support, but will be more costly.
488741
You would have to either write an interface between COBOL program and MS Access, or dump the data base to a text file and have COBOL read the text file. Either way, you would have to write the COBOL program.\n\nIf you are loading to a relational data base, just use Access.
1333
Sorry in advance if Yahoo eats my indentation, but I think you are looking for something like this (tested under Access 2000):\n\n\nPublic Sub FiddlingWithQueryObjectsViaVBA()\n\n    Dim dbs As DAO.Database\n    Set dbs = CurrentDb\n    Dim qrydef As QueryDef\n    \n    Dim sSQLstring As String\n    Dim sQueryNames As String\n    \n    For Each qrydef In dbs.QueryDefs    ' iterate through all the Access query objects\n    \n        sSQLstring = UCase$(qrydef.SQL) ' Get the SQL for the current query\n        \n        If InStr(sSQLstring, "SOMETHING_I_AM_LOOKING_FOR") > 0 Then   ' I found what I'm looking for?\n        \n            sSQLstring = Replace$(sSQLstring, "SOMETHING_I_AM_LOOKING_FOR", "REPLACEMENT_TEXT") ' replace the text\n            qrydef.SQL = sSQLstring     ' update the query object with the new SQL\n        \n            sQueryNames = sQueryNames & qrydef.Name & vbCrLf    ' Maybe make a list of queries modified?\n        End If\n    \n    Next\n    \n    MsgBox "Modified the following queries:" & vbCrLf & sQueryNames\n    \nEnd Sub
227104
Microsoft Access might be a nice choice to start.  If you decide to go to something else, the database file itself can be easily converted to another database program, and it is compatible with SQL and ODBC
531740
try using microsoft access.  use the wizard to make a dat base and tjen it is clear sailing.\nthere are also some othere ones but i dont know their names because they arent in microsoft so i highly doubt that you will have them.
258298
Excel uses VBA (Visual Basic for Applications).  It's a subset of Visual Basic.  A good way to get started with it is to record a macro and then look at the macro's source code.
234053
Use openoffice.org ..a complete office package compatible with all MS formats, free too
791942
First off, the program you designede in visual, are you running it in another visual basic program or are you importing it into another program.  Second, all you need to do to run the program by single key execution is to set the program to a macro.  For more detailed info go to the help section in visual (or press f1) and type in "macro".  Everything you need should be there.  You can send me a direct e-mail if you have any other issues the help won't help with (flyingrizzly@yahoo)
948763
access can import many types of files,  it looks for a hard carraige return to seperate each records out.  You can seperate the fields with comma's.  Then import them into access.  This might not be an easier solution, please let me know if you have any questions. \n\nHope this helps.
28840
Download the free edition of Visual Basic 2005 from the first link below.  When you register, you get access to a free e-book which I think is a great introduction to the system.\n\nThe other two links are Microsoft's sites for Visual Basic and .NET
221896
There's an easy way to do this. I've given you some very basic code.\n\nCopy and past this code into your VBA code under the same sheet as your data. (Press ALT-F11 to get to the VB editor and double click the sheet name of the tab you are working on).\n\nSub SortText()\n    LookRow = 2\n    PutRow = 2\n    txtCounter = 1\n    Do\n        txtColor = Cells(LookRow, 1)\n        If txtColor = "" Then Exit Do\n        txtSize = Cells(LookRow, 2)\n        txtRange = Cells(LookRow, 3)\n        Cells(PutRow, 5) = "Trial #" & txtCounter\n        Cells(PutRow + 1, 5) = "Color " & txtColor\n        Cells(PutRow + 2, 5) = "Size " & txtSize\n        Cells(PutRow + 3, 5) = "Range " & txtRange\n        PutRow = PutRow + 5\n        LookRow = LookRow + 1\n    Loop\nEnd Sub\n\n\nWhen you run the macro it will take the data and arrange it into the columns you wish. Be aware that it will paste the data into column E of the same page and will overwrite anything you have there, so backup your data first.\n\nYou can also assign this to a shortcut-key with Tools>Macro>Macros... You will need your security set to Medium for this to work.\n\nIf you wish the data to be saved on a seperate page, please email me at wabbitt1970 @ hotmail.com
707929
You can use Visual Basic to communicate with Notes like the following:\n\nPrivate Sub InitializeDomino_Click()\nDim s As New NotesSession\nCall s.Initialize\nMsgBox s.CommonUserName, , "Common user name"\nEnd Sub\n\n\nBut if you are realy trying to access Notes through Visual Basic then you need to use COM interface ( Component Object Model ) which allows you to run Lotusscript though VB.  I don't know a lot about doing it this way but if you go into the Notes help and search on COM it has a lot of information.\n\nI hope this helps.