Importing Specific Data from External Programme

[Mark Richardson]

I am producing a database to allow a comparison of two of our products. THe database is fairly straight forward with the user typing in certain fields such as TrackID, ELR Number etc. As well as this information They are embedding pictures of the differences between the tso bits of software. All this i can do. The only problem i am having is the fact that for each embedded picture I also need to import a positional reference from the software. I could get them to type it in but that could lead to incorrect data being inputted. Is there a way that I could tell the database once the objects are embedded to grab the positional data from the software and paste it into the fields. I think the data is held in CSV file. Can this be done??

 

[crosmill]

When your importing from excel you can specify a cell range to import, I don't know if you can do that in a csv file, but you could probably convert it automatically using the FileSystemObject.

Any chance it could be saved as excel to start with?

 

[Mark Richardson]

Not really, i'm looking to grab it from the open file within the programme itself. Which does seem to be quite difficult if not impossible. My knowledge of VB is not what it should be so writing a script is proving difficult.

 

[crosmill]

Sorry I didn't really read the question properly.

Can you get the position of the objects from the other program, I don't thinkn you can do it from access.

 

[Pat Hartman]

Please don't post the same question multiple times. You are getting answers in both threads. This wastes people's time and only confuseses you.

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=44848

You can link to .csv files and query them as if they were Access tables. So as long as you have a unique id, you can find the data you need in the .csv file and update the appopriate fields in the Access table.