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.
Linking has never been my preferred method to manage excel. If I were you I would import it. If there is a specific format you want excel to keep then I would create an auto number field so that the data imports in the order that you have it in excel. Just do an import and find the excel spread sheet you want. Right click on the white work space under table right click and import.
Linking has never been my preferred method to manage excel. If I were you I would import it. If there is a specific format you want excel to keep then I would create an auto number field so that the data imports in the order that you have it in excel. Just do an import and find the excel spread sheet you want. Right click on the white work space under table right click and import.
Good luck
I did that also but the queries are still not ran right. Could it be because the information is duplicated~some families have 25 different trusts but they all have different numbers assigned
Well you have to ask yourself, what identifies this data you want to extract that is unique to the information you want to retrieve. send it to me if you want me to take a look at it. jpgomez80 at gmail dot com, make sure you zip it and then change the extension from zip to .doc
Well you have to ask yourself, what identifies this data you want to extract that is unique to the information you want to retrieve. send it to me if you want me to take a look at it. jpgomez80 at gmail dot com, make sure you zip it and then change the extension from zip to .doc
