Importing files

[BRABUS]

Hi sorry for being a newbie and asking dumb questions but i have done my best to trawl the site using the search features but it turned up nothing.

Anyway.....I am trying to impport data into access and append it all to one table. Currently the data is in MHTML format (dont shout at me yet - its not my choice).

Firstly is there anyway to import MHTML files, I know HTML and HTM are options but not sure if this is possible. Failing this I will have to convert the files to XLS format and then import them

Secondly is there a way for me to import data from say 200+ MHTML or XLS files (depending on the answer to the first point) and append it all to one table. Each of these files is in exactly the same format. The reason i need to import the info into a table is that the files I am importing fropm are deleted every couple of days due to space issues.


Thanks

Rob


PS if I have missed out anything obvious please tell me and I try to tell you what you need to know.

 

[namliam]

Hi sorry for being a newbie and asking dumb questions but i have done my best to trawl the site using the search features but it turned up nothing.

Welcome to (one of) the best access forums on the web, no such thing as dumb questions.

Firstly is there anyway to import MHTML files, I know HTML and HTM are options but not sure if this is possible. Failing this I will have to convert the files to XLS format and then import them

MHTML?? WTF is that??? *Googles* Ah...
Maybe you can take it appart in code yourself instead of manually using excel??

Secondly is there a way for me to import data from say 200+ MHTML or XLS files (depending on the answer to the first point) and append it all to one table. Each of these files is in exactly the same format. The reason i need to import the info into a table is that the files I am importing fropm are deleted every couple of days due to space issues.

Look up the DIR function to find the files...
then use the "Docmd.Tranfer...." to load the files into access. There are different commands for different types Text, Spreadsheet, etc.

Check the access help and post back specific questions here if you have them. Dont be shy

Good luck!

 

[neileg]

There are MHTML converters avaialable to render files into HTML (or other formats). Try Googling.