Results 1 to 3 of 3

Thread: Import this?

  1. #1
    Join Date
    Sep 2006
    Posts
    162

    Unanswered: Import this?

    I want to import data from the clipboard the moment its copied. Not sure how to do this, not important but would be really helpful.

    The data will be the same, but not always the exact format.

    Here is a small example of the data.

    Base: 12
    Pit: 0
    Chamber: 15

    So I'll have a field named Base, Pit, Chamber and so on. Hows the best way to import this. So I'll need it to look up Base then take the 12 beside it and add to table.

    Currently I am pasting in excel and it rearranges it then i import it.

  2. #2
    Join Date
    Sep 2006
    Posts
    162
    Any ideas.

    If I have to paste into a txt file thats better than goin thru excel for me. Any idea for this way too?
    Last edited by Jay59; 09-14-06 at 13:54.

  3. #3
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    Short of possibly some character recognition type of program, I know you can paste stuff from the clipboard into an image field with a simple vba command but I don't think that's the solution you're looking for. (I also can't remember the exact vba command.)
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •