Search results

I have a text file with 261 fields that I need to import inot Access. Due to the limitation of 255 columns in an access table I need to import the fields into separate table. I have attempted to do this using the below code. I am receiving an error of "Syntax error in FROM clause" any help...

I am looking for a way to selectively choose which files I extract from a Zip file. I believe that VBA can open a zip file and review the contents, but I am stuck on where I should start. Does anyone have experience doing this?