467,885 Members | 1,262 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,885 developers. It's quick & easy.

Linking Excel spreadsheet to Access

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
Feb 22 '07 #1
  • viewed: 3966
Share:
6 Replies
maxamis4
Expert 100+
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
Feb 22 '07 #2
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
Feb 22 '07 #3
maxamis4
Expert 100+
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
Feb 22 '07 #4
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
hee hee-I"m an idiot-how do you zip?
Feb 22 '07 #5
maxamis4
Expert 100+
you should be able to right click on the file and an option will be there that says send to compress

that should do it
Feb 22 '07 #6
NeoPa
Expert Mod 16PB
you should be able to right click on the file and an option will be there that says send to compress

that should do it
You will need to install some ZIPping software I think.
Try WinZip as just one place to get something quickly.
Feb 26 '07 #7

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by Mark T. | last post: by
12 posts views Thread by slinky | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.