import to Access

nyj has asked for the wisdom of the Perl Monks concerning the following question:

Hi Brother Superior I need to be able to import a CSV file into an Access table in a perl script. I'm using OLE in ActiveState on Windows XP pro, and a lengthy trawl of the internet has not yielded much of anything - I was hoping someone has some example code on how to do this

Comment on import to Access

Replies are listed 'Best First'.
Re: import to Access by Corion (Patriarch) on Jul 20, 2010 at 12:47 UTC
You likely need to work on your search technique. Asking short questions without any research in quick succession is not good research. See DBI, which Perl import to access should also turn up.	[reply]
Re^2: import to Access by nyj (Novice) on Jul 21, 2010 at 14:58 UTC
Ummmm . . . I've been around for a while, and I did do some research, including searching on 'perl inport to access' and I'd found that DBI site all on my own, but it says nothing about the question I actually asked.	[reply]
Re^3: import to Access by Corion (Patriarch) on Jul 21, 2010 at 14:59 UTC
I guess you will have to write some code then. Maybe you want to combine Text::xSV with DBI (using DBD::ODBC and then come back once you have code and questions?	[reply]