User Profile

Collapse

Profile Sidebar

Collapse
mc223
mc223
Last Activity: May 28 '10, 07:48 PM
Joined: Mar 21 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • mc223
    started a topic VBA code to import data from excel to oracle
    in Visual Basic

    VBA code to import data from excel to oracle

    I have an excel sheet which has connection to Oracle table.I want VBA code which will enable the chaNges the user made on the excel sheet to refelct in ORACLE tables.
    May be we can write a code on Command clcik to update all the changes the user made on excel sheet to reflect in oracle tables.
    Can anyone please share the code.

    Thanks in advance
    See more | Go to post
    • mc223
      replied to Replace new line character with space
      in Access
      I actually tried the above query twice:once with chr(10) and next update query with chr(13) and it worked fine then
      See more | Go to post

        Leave a comment:

      • mc223
        started a topic Replace new line character with space
        in Access

        Replace new line character with space

        I have data in ms access which has new line characters.I want to use the REPLACE function to replace all new lines in that particular column so that the data appears in a single line.What update query should I use?
        See more | Go to post
        No activity results to display
        Show More
        Working...