Search results

I'm having a strange error when importing a big spreadsheet with Access. The excel spreadsheet has around 5300 rows and I am using to following command to import: DoCmd.TransferSpreadsheet acImport, 8, "portal_sgn", "U:\old_users\portal_sgn.xls", True, "B2:E" When I try this it only imports...

I have one table that I want a user to be able to select multiple options from a list to "add" to the table. Therefore I created a third table that will have two colums: 1 for the unique ID from table 1 and one for the unique ID from table 2. No primary key will be chosen as multiple table2's...

I have lots of CSV files that are per day and are as follows: File 1: Username Time Bob 2 Joe 6 File 2: Username Time Joe 8 Sue 6 Essentially what I want to do is import each file into one table where if the username is not in the database it...