Paste clipboard to record?

[bitRAKE]

First let me say that I'm new to Access, but not VBA :->

I'm using an external program that exports a report to the clipboard. I want to run this a few thousand times and create records in an Access database. In the past I've just pasted the clipboard in an Excel sheet. I can specify what character separates rows and columns.

Thanks in advance for your help,
bitRAKE )

 

[ghubbell]

What/Where is the external data coming from? Have you tried to pull it in to Access directly: Files-Get External Data-Import and select one of the multitude of file types?
Gord
ghubbell@total.net

 

[bitRAKE]

I execute the other program (object really) through a COM interface - programmatically. I don't want to have to do this manually a few thousand times. ) I wish there was another way to access the data - the interface to some hardware is custom and copywrite with no docs :-> bitRAKE )
Please, reply to board

 

[bitRAKE]

I figure in the worst case I can paste the data into an Excel sheet like I was doing and then import the records into Access, but it'd be nice to just paste into Access.
Thank you, bitRAKE )
Please, reply to board