472,802 Members | 1,379 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,802 software developers and data experts.

Linking Excel spreadsheet to Access

21
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
6 4240
maxamis4
295 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
jalmar
21
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
295 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
jalmar
21
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
295 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
32,534 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

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

Similar topics

4
by: Mark T. | last post by:
Hi, I've got a simple DB (Office Win XP Professional). Basically, it's like a check book register - deposit, deduction and running sum. I'd like to somehow link it to an Excel spreadsheet that...
1
by: Johnny Meredith | last post by:
Dear All, I have an Access database that tracks the progress of income tax audits. When the taxing authorities make a change (an "Adjustment"), I record the pertinent information in the...
1
by: garry.oxnard | last post by:
Can anyone help me to solve a problem which involves switching from Access to Excel (then back to Access) programatically please? I have an Excel template which, on open, also opens an Access...
2
by: billelev | last post by:
hi there, This should be a very quick question to resolve. I have linked to an excel spreadsheet from Access for the first time. My understanding was that whenever a change occurs in the...
1
by: smaczylo | last post by:
Hello, I've recently been asked to work with Microsoft Access, and while I feel quite comfortable with Excel, I'm at a complete loss with databases. If someone could help me with this issue I'm...
3
by: ineedahelp | last post by:
Hi and HELP!, I am using Excel and Access 2003. I am trying to create a link to an excel spreadsheet and append the data from a specific sheet called "PEJ". My error is runtime error 3125 "PEJ$"...
12
by: slinky | last post by:
Can an Excel spreadsheet or a section of one be embedded into an Access form and serve as a subform from which other parts of the Access form can get data? Thanks!
1
by: karthik28 | last post by:
I tried linking an excel spreadsheet to an access database. It shows me a window with the data but the header row in missing. However, when I open the excel file, save it without making any changes...
0
by: Tony Hine | last post by:
Problem for Excel Developers One of the problems facing Excel developers moving into MS Access is actually the apparent similarity between MS Access tables and Excel spreadsheets. MS Access is...
0
by: erikbower65 | last post by:
Using CodiumAI's pr-agent is simple and powerful. Follow these steps: 1. Install CodiumAI CLI: Ensure Node.js is installed, then run 'npm install -g codiumai' in the terminal. 2. Connect to...
0
linyimin
by: linyimin | last post by:
Spring Startup Analyzer generates an interactive Spring application startup report that lets you understand what contributes to the application startup time and helps to optimize it. Support for...
0
by: erikbower65 | last post by:
Here's a concise step-by-step guide for manually installing IntelliJ IDEA: 1. Download: Visit the official JetBrains website and download the IntelliJ IDEA Community or Ultimate edition based on...
0
by: kcodez | last post by:
As a H5 game development enthusiast, I recently wrote a very interesting little game - Toy Claw ((http://claw.kjeek.com/))。Here I will summarize and share the development experience here, and hope it...
0
by: Taofi | last post by:
I try to insert a new record but the error message says the number of query names and destination fields are not the same This are my field names ID, Budgeted, Actual, Status and Differences ...
14
DJRhino1175
by: DJRhino1175 | last post by:
When I run this code I get an error, its Run-time error# 424 Object required...This is my first attempt at doing something like this. I test the entire code and it worked until I added this - If...
0
by: Rina0 | last post by:
I am looking for a Python code to find the longest common subsequence of two strings. I found this blog post that describes the length of longest common subsequence problem and provides a solution in...
0
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
0
by: Mushico | last post by:
How to calculate date of retirement from date of birth

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.