Help With Linking Excel Into A Stores Database
Oct 9, 2006
first time poster, please be kind.
I am currently updating our supply stores database in work. When an item becomes unserviceable we need to attach a form to the item before sending it away. i would like the data entered into the 'unserviceable' table within my database to be transposed onto an excel spreadsheet (see attachment) and then automatically printed out with the data in the relevant boxes. Can anyone tell me how this is done please? My knowledge of access is rather limited and I am teaching myself as I go along.
View Replies
ADVERTISEMENT
Jan 15, 2006
I want to use the data contained in Access table in an Excell app. What is the best way to link them - preferably in 'real time' - is there a way excell can read directly from the tables? We need to analyse some of the data in the database through Excell....
Any suggestions welcomed...?
View 8 Replies
View Related
Feb 3, 2006
I'm trying to link an excel s/sheet into a database, however the link wizard doesn't give me the option of setting field types (text, double etc). It's skipping that screen.
I've changed the s/sheet so that all cells are text but on linking the table sets 2 fields to number and I'm losing some textual data.
However if I copy the cells in excel, open a pre-built table with field types set and do paste append, all data is visible.
Therefore, I'm trying to see if there's a way in code I can get access to open a specific excel s/sheet, copy all, open database table and paste append.
Any Ideas?
View 3 Replies
View Related
Feb 16, 2007
Is there a way to link a ACC table to an Excel spreadsheet so that when changes are made to one it automatically changes the other?
And -
How do I link (or join) two (or 3) Access tables so that the above happens - when a change is made to one it's made to the other.
Example:
I have an overall big table with 7 fields.
I created a query from it that has 5 fields. Or create another table that has 5 fields.
Can I join/link them so that changes made to one is made to the other?
Example:
An ID number changes
or a wage salary changes.
Thanks in advance.
View 2 Replies
View Related
May 23, 2005
I have an excel spreadsheet that i have linked to an Access database. I need to append and delete records from the spreadsheet into an existing table in my Access database. I am able to append specific records from the spreadsheet into my table but then i want to delete the records from the spreadsheet. When i run the delete query i get the following message; "Deleting data in a linked table is not supported by this ISAM" Is there some way i could get this to work?
I have records in this spreadsheet that needs to get into the database but once it is appended to the database i need those records deleted from the spreadsheet. I am kinda using this spreadsheet as a temporary table so one employee who does not use access can put data into his spreadsheet and then the other employees can pull want they need from this into the database.
Any suggestions?
View 5 Replies
View Related
Nov 23, 2006
I have a table which is being populated with data when I click a button in a form. Now I want the data of the table to be shown in an excel file but the problem is that I want that data to be refreshed everytime I insert new data in the table.
Any ideas??
View 3 Replies
View Related
Sep 7, 2011
I'm trying to set up a simple query that links four tables. However, the tables are extremely large, all in excess of 1.5GB each so I had to split the tables up into four separate DBs. I've tried the following with no success:
1) Link the 4 tables in the DB which contains my primary key. This quickly inflates increases the file size above 2GB and won't let me go any further.
2) Build a remote query to connect the four tables. This looked promising until I tried to run the query and it became evident that it only knows to point to the last database source that you specified.
I'm running everything locally on my C drive. The data source are simple text files (1.6 million rows) from the FDA website.
View 3 Replies
View Related
Jul 31, 2007
I have a table in Access databse link to excel file in the network, the format of the fields of this file are set to general. When I create a link table wizard the fileds formats changes to numbers for some of them. It's wierd, I spent a lot of time figuring out what is the problem and creating new excel file with changing the fields format around and still not solving the problem. Any idea or help for this problem is apperciated. Thanks
View 2 Replies
View Related
Jul 31, 2007
I have a table in Access databse link to excel file in the network, the format of the fields of this file are set to general. When I create a link table wizard the fileds formats changes to numbers for some of them. It's wierd, I spent a lot of time figuring out what is the problem and creating new excel file with changing the fields format around and still not solving the problem. Any idea or help for this problem is apperciated. Thanks
View 2 Replies
View Related
Feb 13, 2006
Hi! This may be an incredibly simple query. We have access users and non-users at our organisation.
Although our database is in access, the non-users would like to use excel, so I am trying to set up a link between the two.
I have managed to set up the link between the main database table and an excel spreadsheet, but I also use a form to enter info on the main database.
When I set up the link, I add something to the main database table and it changes the excel document... but when I change a name or something on the form, it doesn't change it in excel.
Any ideas how I can link all of it would be very much appreciated!
With thanks, Hayley
View 1 Replies
View Related
Jan 7, 2015
I am creating a database for the company I work for. My boss wants it to have every information possible stored and accessible through the one database. Right now the time sheet that we use is a hard copy that the guys fill out and turn in each week. Before the database started I created an excel sheet for them to start using. My boss wants me to link the excel sheet to a table in access. The way it would work is each of the guys would fill theirs out and email them to me by Friday. I would then link it to the table so that we could easily pull information we needed through a query.
I read online on the office support website that you can link a spreadsheet but then access does not store the data and the data if needed to be changed had to be done through the excel spreadsheet. Doing it like that made it sound to me that each time sheet that was turned in each would would create a new table. I was hoping there was a way to have one table with all the times on it using an employee number as the relationship key. The biggest thing though is that the guys have to use excel to fill out the time sheet because getting each guy access is "not an option" .
View 14 Replies
View Related
May 16, 2012
I'm trying to use a template to track assets-specifically this template:URL....Is there a way I can link an excel doc to my database that provides all of my data, that is thereby linked to other tables within Access?I want my data to be updated as it is manipulated within the independent excel doc when I open access.
View 6 Replies
View Related
Sep 18, 2005
Hella all,
I'm new to this forum :) so I say hello to all of you :)
I have a little problem..
I have a table wich stores information wich comes from a combobox.
The problem is that it saves the combobox ID instead of the text.
This is the row source of the combobox
SELECT rapporteur.ID, rapporteur.rapporteur FROM rapporteur;
Could somebody tell me how I can store the rapporteur.rapporteur in a other table instead of the rapporteur.ID?
thx a ton in advance
View 7 Replies
View Related
Sep 18, 2005
Hi, I'm new here also. I'm afraid I can't help with your question, but I have 2 questions of my own.
1) how do you start a new thread (as you have done?)
2) in my database I have thousands of contacts. How can I add an alphabetical index tab along the right edge such as in Outlook for one-click access to different parts of the database?
Thanks and I hope you can help!
Gary
View 2 Replies
View Related
May 23, 2006
Hi,
I am using group options and they store a number instead of the vaules you typed in, is there anyway of making a group option that will store values and not numbers?
View 9 Replies
View Related
Oct 6, 2006
I have a form which is associated with a table. When I put some values in the fields which are connected to the database and try to close the form, it gives me an error that "Can't insert record the primary key might be duplicated"...! and then it closes.
Does the form store a record in the table while closing??
If so is there a way to prevent it??
Please reply..
View 3 Replies
View Related
Oct 7, 2013
Does access have WITH subquery, For example creating a variable that stores a whole subquery such as:
Code:
WITH variableTEST (a, b, c, d, e) as
(SELECT a1, a2, a3, max(ab), count(*) as nbids
FROM A x natural join B y
WHERE x.something > y.something
GROUP by a1, a2, a3)
WITH variableTWO (f, g, h, i, j, k, j) as
(SELECT A.bidder, W.a, W.b, W.c, W.d, W.e, A.something
FROM variableTEST W natural join B A
WHERE W.sprice = B.bidprice)
SELECT h FROM variableTWO WHERE now - j <7
Can it do something like this, if not what alternative do they have to do something similar? Using WITH and subquery and variable, and storing variables and then later use it again in another subquery, can it do something like this in access SQL?
View 5 Replies
View Related
Nov 4, 2013
I have a number of Excel spreadsheets (data sources) hosted on Sharepoint that I need to link to one single Access database.
At first. I cannot link the spreadsheets directly to Access because Access cannot read the spreadsheets on SharePoint to make the links.
Secondly, I can export the spreadsheets from SharePoint to a local folder on my PC and keep them 'refreshed'. The problem with this is that I cannot link Access to the local refreshed spreadsheets because of the (auto) extention .iqy. Access does not know the extention .iqy and hence the two cannot be linked at all.
Thus: How do I link an Excel spreadsheet hosted on SharePoint to MS Access.
View 3 Replies
View Related
Mar 27, 2014
I am trying to link an excel file (.xlsb) into Access 2013 running on Windows 8 (External Data-->Excel). It will first act like it's working, but it will just shut Access down after a couple seconds of churning and ask for a Backup to be created or it will restart (no rhyme or reason as to which you will get). I've tried a Compact and Repair. I've tried rebooting. I've tried renaming the excel file(although I have other files with the same naming convention linked), but no matter what I do, it will not accept it. I've tried doing just a straight Import....same results. This file, along with a others that are already linked in this database, are stored on a network server.
View 7 Replies
View Related
Dec 6, 2012
Having experimented with Access for a few months now; I know you can link an Access Database to SharePoint, and you can export Excel files into Access for inclusion in tables.
My question is; If I have a daily report being produced, through script, with an excel output. Is there anyway to automatically publish this in Access, negating the need to manually go into Access to import?
View 5 Replies
View Related
May 24, 2006
Hi,
im after a option group that stores multiple values, the only way, long winded as it will be is to create a table with all the values then have tickboxes for all of them.
Is there a simpler cleaner way?
View 1 Replies
View Related
Dec 2, 2013
I am trying to count how many plans a retail chain has over its stores.
So
WeekNo | StoreNo | Product |PlanNo
1 | 10001 | Dog | A
1 | 10001 | Cat | B
1 | 20008 | Dog | B
1 | 30005 | Dog | B
Query/report to show
Product | PlanNo A | PlanNo B
Dog | 1 | 2
Cat | 0 | 1
Numbers in Query/report are a count of Stores selling the product
One of the issues is that the data is duplicated over the weeks, I'm thinking to use max on week number so It only looks at the last available data. And how to write the query.
Currently I'm doing this
PlanA: Sum(IIf([PlanNo]="A",1,0)
PlanB: Sum(IIf([PlanNo]="B",1,0)
.
.
.
But it looks at the whole of the table for all the weeks...
View 14 Replies
View Related
Jun 27, 2005
I have a field on my Form. The form holds all the information about Artists under our record label. I need to be able to attach a copy of each artists contract to their separate form. I just found out that you can't physically attach this. Does anyone have any ideas and how I could play this. Any ideas would be well appreciated.
Thanks
Shane
View 2 Replies
View Related
Dec 1, 2005
I use a packaged software program at the dealership I work at. In the past I have been able to pull queries and information out of the database and into Excel. The query builder pulls the data as read-only and thus no fear of changing the main database. I have developed an access database for doing commissions. I want to be able to link my database with the companies database as read-only. This would save typing a lot of the duplicate information (ie customer name, date etc.). I have been able to successfully link the 2 databases but realized quickly that anything I change in msaccess will change on the main database. I don't want to corrupt the main database and really only want to pull the information for viewing. Any comments or help would be greatly appreciated.
Thanks
Rob
View 6 Replies
View Related
Nov 13, 2007
Hi - I have a front end database that is linked to 2 backend databases. I'd like to add code so that after the splashscreen pops up it checks to see if the front end is linked. If not then asks the user to enter the path for the two backend databases. I need your HELP!!1
Bukaw
View 1 Replies
View Related
Apr 7, 2005
I have recently updated my version of Access.
Within a tbl i have a series of hyperlinks.
All of these hyperlinks are linked to an object within the database, a macro as an example.
When i go to edit these hyperlinks, it does not allow me to link 'to objects within the database'. This options used to be available in my older version of Access. Am i missing something?
View 3 Replies
View Related
