Search results

I reinstalled Access and now the import works fine. Thanks for the help.

I didn't know you could import a file without having a table first, but I received the same error message in doing it that way. I also tried converting it to a text file and importing it but same problem. Do you think it could be a problem with Access itself and not the database or file format...

I dont have control over how the CSV file is exported to us and it's too big to open in Excel. Anyway, we've imported much bigger CSV files in the past so I dont think it's the size. Any other ideas? Thanks.

Nope, I created a new database and table with the same number of fields and same field types as the original and got the same error: "Microsoft Access has encountered a problem and needs to close. We are sorry for the inconvenience."

Every time I try to import a CSV file into my Access database it crashes. I've tried repairing it but the repaired database crashes as well. Any ideas on what could cause this? Thanks.

I found out how to link to Excel from Access. In Access I created a link to the Excel file. So Access is now linked to the Excel data just as it would a table from another database. So then I tried creating the query in Excel which uses the Excel-link in Access. But in the first step of the...

In Excel I have a sheet with about 3000 rows. Each row has an id. I need to retrieve a field from an Access database for each id in the Excel file. I know how to query the Access database from Excel, but I don't know how to set the query to use the id's in the Excel sheet instead of an Access...

Let's say I have 2 tables, tableNames and tableSales. How would I select all of the names from tableNames that don't exist in tableSales, or exist in tableSales but have 0 sales? tableNames has 1 column for names, tableSales has 2 columns for names and amount. This is an example but very...

Thanks krunalprajapati. I got it working before you responded but hopefully someone else will find this of use.

Hi, Lets say I have a table with 4 fields - product, location, transactions, cost How do I select all the products (and their location) from the table that exist in the table more than 4 times with transaction=0 and cost>3? There might be records for the product with more than 0 trans or < $3...

Lets say I have 5 rows of data in my database. Each row has 3 fields and the first 2 fields are the same in each row. I need to return the first occurrance of the third field. So if this is my database: A B C A B D A B E A B F A B G And this is my input: A B I need a query to return this...

In other words, I need to return each row at least once but no more than once. The rows have 2 columns. Thanks.

Hi, I have a table with two fields and thousands of rows. In some of these rows, the second field has a duplicate. Like the following: a 1 b 1 c 1 d 2 e 3 How would I write a query that returns all unique rows and just one of the rows that has a duplicate second field? Such as: a 1 d 2 e 3...

In the first code example, if you use "WHERE...IN..." it returns each row with a duplicate field twice. If you use "WHERE...NOT IN..." it doesn't return rows with duplicate fields at all. How do you modify it to return all unique rows along with only one row with a duplicate field? Example: a...

How do I edit the field list of a form? I need to add another field to it. Thanks.

Thanks, that was my next guess ;) Just kidding. By the way, how would I pull records that have dupicate field1's AND field2's? Thanks again.

How do you select duplicate fields from a single table? If the table looked like this: a 5 b c 5 d e 5 f g 6 h z 4 y I would need to select the first three records because they each have a duplicate field2 value.I'm thinking it would look something like this: SELECT field1,field2,field3 FROM...

Hi, I'm trying to create a query that will return strings from one table that don't contain certain words which are located in another table. So I have two tables. One table has a list of strings, and the other table has a list of words. I want the query to return all strings from table A that...

Thanks Wayne. I also need to know how to run a SELECT query.

I have a table with 1 field which contains strings. In an Access '97 module, how do I loop through this table and assign each string to a variable? For example, lets say I have the following table: Field of Strings -------------- This is string1 This is string2 I need to get the string in the...