Recent content by GoodOmens

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...

Uhh to give you some background ... we are tracking documents (in this case what we refer to as a SARF) and need to know who is working on the document at a given time. MS had a built in pre-defined DB for tracking company assets that we modified to use in our case. So in short don't pay...

You are right but without getting to complex this data was not originally designed to be in a database but was setup to use excel. I've been tasked with making it more DB friendly :-( I want a subform inside the ASSET form that allows you to select multiple SIAF items (from the SIAF table)...

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...

Ahh thats a good approach. I'll see if I can import my data that way ... unfortunatly I am tied to how the data is given to me as csv files.

Hmm cool! I managed to figure out ... I imported one of the sheets into access then added the columns I needed. I then imported each data sheet as a seperate table. I then did the append query to the first table to get any usernames not in the first table. Lastly I did a update table from...

I tried exactly this, but as you already stated it only added new records, it did not add anything to usernames that already existed due to key violations. Thanks for the quick replies! Now what I have is seperate tables with each "time" for each day. Each table is as follows: Table day1...

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...