We are receiving a report out of peoplesoft containing class schedule information. Due to the length of some of the fields the only way we can export the data from peoplesoft is to a *.csv file. Unfortunately, Peoplesoft has some idiosyncrasies that cause problems when migrating to access using this file.
I've tried several solutions, but none allow me to have the functionality that I must have in order to complete the application.
A side note...can you connect to an excel file and an access database in the same ASP file? When I tried it told me the Microsoft Access Driver could not open my excel file, so I am guessing it took priority over the excel connect file and tried using that one driver...?