DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2006

    Exclamation excel to pervasive

    i dont know if anyone is familiar with what im talking about, im actually engineering, but since no one else seems to be able to figure this one out im stuck with it.

    basically i have a scenario where we have a parts list in excel (60,000) and they are in a 3 column (pn, description1, description2) format. we could copy paste right to the database using access, but that would be real time and potentially mistakes would be huge mistakes, that and it puts me in a security position (i could commit corporate fraud, etc) basically i need to be able to enter these parts and modify their descriptions in accel and then ad them into the system 1 at a time.

    to make matters worse the system is set up such that once i am done editing 1000 or so descriptions i have to play the alt tab, alt c, alt v, game copying and pasting one cell at a time to its appropriate field in the pervasive program macola itemmaster (that what we call it, though i dont know if others use it at all)

    i wanted to try to use c++, but it doesnt seem to be working for me, and excel macros wont switch between the two programs, so i was told to look into visual basic.

    having been dissapointed before i thought i would search for people that knew more than i did before i invested some serious time of teaching myself to use visual basic.

    basically i need to know if and how to do one of two things. if somehow i could tell the program to actually do the key command string that i enter to move one entire pn,desc1,desc2 set to "itemmaster" and then loop that program until a designated time, that would work.

    or if i could tel the computer to copy and paste 1 cell at a time from excel to the field in pervasive, macola, itemmaster, then that would also work.

    a find and replace idea wont work though for our system (unfortunately)

    so like i said i need a way to get the computer to copy "A1", switch to another open window, and paste that cell into a location, switch back to excel, copy "b1", switch to the other open window,tab over once, paste cell, switch back to excel, copy "c1", switch to the other open window, tab over, paste, enter, switch back to excel, and start all over again with the next row.

    any help would be great. furthermore i might even be interested in paying someone if they could actually do it for me.

    let me know what you guys think as far as possible solutions


  2. #2
    Join Date
    Aug 2005
    Just use the data import feature in Access. enter the data in your Excel spreadsheet. Then go in to Access and select File - Get External Data from the menu and follow the dialog boxes [see attached screen shot] that are displayed to connect to your Excel file and import the data. You could even write/record yourself a little macro if this will be a repetitive function.
    Attached Files Attached Files

  3. #3
    Join Date
    Feb 2006


    i dont think that will work, import is a command that is similar in funtion to me just highlighting cells and copy, pasting them in.

    this would require import to recognize that one cell goes in a certain field. in other words what im copying into does not have a row colum format, it has 3 random locations on a window. its not copying one database to another. thats the issue.

    i need it to recognize a specific location that the single cell needs to be imported into, not just another cell "a1"

    thanks for the input, any other ideas?

  4. #4
    Join Date
    Feb 2006
    and i think i typod, its progression explorer that i am copying into

  5. #5
    Join Date
    Feb 2006
    also i dont want to do access because the companies live data is there and there is potential for huge errors and such, i dont want to be in that position.

  6. #6
    Join Date
    Feb 2006

Similar Threads

  1. Replies: 8
    Last Post: 01-23-2006, 03:27 PM
  2. Upgrade from Excel 4 to Excel 2003`
    By salinas31 in forum VB Classic
    Replies: 0
    Last Post: 04-21-2005, 10:09 AM
  3. Replies: 0
    Last Post: 07-08-2002, 11:37 AM
  4. ANN: Active XL Report 4.1 - Excel reporting with practically no coding
    By Alexander Frolov [Afalina Co., Ltd.] in forum vb.announcements
    Replies: 0
    Last Post: 06-24-2002, 12:13 PM
  5. ANN: Active XL Report 4.0 - Excel reporting with practically no coding
    By Afalina Co., Ltd. in forum vb.announcements
    Replies: 0
    Last Post: 04-01-2002, 09:39 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center
Latest Articles
Questions? Contact us.
Web Development
Latest Tips
Open Source

   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.