Hello again:
My second question is:
I am linking an excel spreadsheet into Access, I have it linked and at first had problems getting the information imported into Access-it wasn't importing-I had a msg in the populated fields which read #NUM- I was told to use quotations before and after the numbers in Excel and it would import correctly, which did happen but when I run my query off that linked table, it creates far too many records......and information is duplicated far too many times. Can anyone help me with this problem. I am trying to import dates into an access table. The spreadsheet lists many different trust numbers and then dates these trusts were signed~I link the spreadsheet to Access and it pulls the information in as is listed in Excel but when I run the queries, the first record contains all the information but dates are entered where they shouldn't be and then there are at least 1400 records with the same information. Again...hope this is clear and someone is able to help, I've been working on this for days.
Thanks in advance