New CSV has broken my database

[boomtastic]

Hello,

Recently I inherited an Access database that uses a CSV file each day to get it's input. This CSV was changed and now includes more columns, which in turn does not allow the database to process it. In order for me to get the database to digest this CSV, I either need to remove the extra columns or start working on the database to accept it. Of course my boss has chosen the 2nd option. I am scouring the Internet to help me understand Access, how to change the macro, queries, tables, etc. Are there any good resources/links that I can be pointed towards to help me understand how to make the necessary changes to my existing database to accept the new CSV input? My thanks in advance.

 

[Scooterbug]

I'm sure there is an import specification that was being used when the orgininal csv file was being imported. All you have to do is to change the spec and you should be good to go.

Check the code behind the import. There should be a line like this:

docmd.transfertext, "SpecName"

Now, do a manual import of the file. Setup the fields as you want them...and when you are done, click the Advance button. Then Save As.. and name it the same name as the spec from the transfertext line.

 

[boomtastic]

Thank you Scooterbug. I read my original post after I read your reply and realized that I forgot to say the CSV has remained in the same location and with the same name - just the contents inside it have grown with more fields. Your reply was useful though because I learned something though (hadn't found the code under I went searching)! Thank you again!!