0
votes
1answer
17 views

Easiest way of porting data into a database

Recently, I received a lot of information from one of my friends who made a quiz type program. He asked me to help port it into an Access database. His program places all the info in a grid; around ...
0
votes
2answers
67 views

Split date time, with only time, into minutes and seconds

I'm creating an Access database from an excel file that contains metadata about vhs tapes and DVDs. The person who created the excel file had the running times as a date/time field in minutes:seconds. ...
0
votes
0answers
1k views

How to bulk import multiple CSV files into master tables with variable field names?

As a learning exercise, I am trying to map several data files into a few master tables. Right now, I have a file hierarchy as follows: <Root> - Client 1 - CustomerInfo.csv - ...