Export to Access

[DanBrill]

Hi Everyone! Long time away from the Forum. In a pinch and need some help. I have a project where I'm being foced to use a program with an Access backend.

I have a bunch of data in a FileMaker 7 database. I'd like to be able to find the record I want in FM, run a script, and export a single record to an Access table on the fly.

Everything is set on the FM side. Click a button and it dumps to a tab-delimited file. Can anyone point me to some resources so I can get Access to import this record into a table?

Thanks for any help, especially since, as I read this back to myself, its only tangentially a FileMaker question.

Thanks,

Dan

[Wim Decorte]

You need to code something in VBA inside Access to make this work. Plenty of VBA sample code out there on the Internet. If you've never programmed VBA it can be daunting so you might have to find someone who'se proficient at it.

The whole process needs to be streamlined to: your FM script somehow needs to be able to call the Access macro after it dumped the text file. Or you need to put Access on a timer so that it looks every x minutes for a particular file in a particular folder.