Hi,
after reading the article "Importing Excel...Data into MySQL Using Navicat", I've dl the soft. very good one.
The question is: is it possible to import a large amount of html files stored on my local hard drive in a directory, record them in a table(local), in a single process?
(actually using the import wizard, I import the files one by one, it's not really enjoy me to repeat the operation 3 thousand time...)

I guess I should use the command line, but I'm a rookie, and I haven't really understand how to write the right command line to perform the operation.

By the way, my operating system is win xp(yes, u can laugh, it's me charlie brown), I use easyphp , I'm french, not speaking english very well, I hope this message is readable.

Bye,
grego

    3 months later

    Hello,

    I believe I'm having the same problem that Grego had, except I'd like to import a folder full of Excel files, not html's.

    Navicat and the import feature are great. However, I'm looking for a way to import multple separate excel files into a MySQL table. As far as I can tell you have to import one file at a time with Navicat. Is there anyway to batch this process? The 170 excel files I will import once a month, will make individual imports a timely and error prone process.

    Can this be done through Navicat or programatically. My other alternative is to create one large excel file out of the collection.

    Any ideas, would be greatly appreciated?

    J.

      Write a Reply...