i need to link my db to my excel.
if i input data to my db then the data will appear also to my excel.
is it possible?
please help. i need it very badly.
thanks
I need to convert all these indidvual text files into either excel or access.
What should i do inorder for these text file to allocate to the right Field name in row once i click a import data from text file?
Any advise or example?
i want to create a link to access table with excel file when i change any value in excel it update in access automatic
View 1 Replies View RelatedI'd like to import an excel file but the data begin from cell "A10", above there is a "privacy text".Is it possibile import or link the excel data in an access table directly from the cell A10?
View 1 Replies View RelatedI have a table called tblDeliveryOverview and a table called tblPurchaseOverview in the relationship there is no link between each other but i've used a query to link the one field from tblDeliveryOverview to tblPurchaseOverview.
How can i prevent a record update from happening when i update a record in tbleDeliveryOverview and the same gets updated in tblPurchaseOverview, which i don't want to happen.
hi
i'm trying to create a database but i'm facing some problem in qury
my database contain two fields which are
recieved date and released date
both of them contain dates
i want my result to be like :
date
1-2-2008
2-2-2008
3-2-2008
4-2-2008
5-2-2008
6-2-2008
7-2-2008
8-2-2008
9-2-2008
10-2-2008
.
.
.
.
until the end the of the month
recieved
5 1
-
1
-
1
1
-
-
1
released
1
-
-
1
2
-
-
-
-
1
date will view the dates
recieved example will view how many time 1-2-2008 is repeating in the recieved date field
released example will view how many time 1-2-2008 is repeating in the released date field
finally i would view the total of the recieved and released
i hope that i will get a help from somebody
I need a little help in the following topic:
There is an Access (2002) database used at our company covering its different tasks; different mdb files are used for different tasks (storage, invoicing etc.). All of them are linked to a central file that holds the tables.
Some of the users use more files; the same colleague uses for example the storage module and the service module.
I'd like to keep it this structured but I'd like to make it easier to change between the files so the user don't have to quit manually from the storage moduel and open a service module, giving his password for the tenth time per a day.
Could you help with an advice how I could do with VB that by clicking on a button the presently used file closes and another preprogrammed one opens.
(For closing I'm using DoCmd.Quit but no idea how to open something)
I really appreciate your help.
Peter
Hi all,
I have added about 15 links on a form, linking to word and excel documents. The word documents open fine but all of my excel documents pop up with a messae saying the file cannot be open, yet when i just go to the document on my hard drive they all open fine...does anyone have any ideas please. Thanks
Hi,
I'm new to this so please go easy!
I have an excel document which automatically refreshes data gathered from an access db.
I need to put a button on the switchboard on the same db to open the excel document, basically to make it easy for others to find.
I have tried hyperlinks but it doesn't want to play. It locks the db and then won't refresh the information.
I know i'm missing something blindingly obvious, can someone help?!
:confused:
Thanks
elsiegee
I know I have seen this asked before but couldn't find the topic using search, so forgive any duplication.
I have an excel file linked to an Access database. So far so good, except that some of the fields in the spreadsheet show #NUM! as the value. Mostly this is #N/A in the source file. I don't have control over the creation of the file, and it is read-only so I can't even go in and remove the #N/A cells.
What I want to do is create a query that will essentially replace any #NUM! value with a default value. Sort of like using NZ() to replace Nulls in the source.
Is there a function that will do this?
I tried creating a VB function, but essentially, when the "#NUM!" would be passed in, VB would error out and return the same "#NUM!".
I know that Access will strip them out if I import the excel file, but I need to see the latest data from the file, and I don't want have to reimport the file every time I run a query.
Any help is appreciated.
David
Access 2000
How do I link a table to excel table so if I add or change things it changes in the other.
Bub :rolleyes:
Hello
Im having trouble with access and im kinda new to it so ne nice ;)
Ive searched the forum and i havent found anything helpfull...
I want to link a single cell in excel, another file, to my access query... how can i do this?? Thank you in advance. :)
Please would someone be able to advise me how I could link an Access Query to an Excel spreadsheet. Also, is it possible for the Excel spreadsheet to be 'updated' automatically when the data in the Access Query is updated ?
Many Thanks
Richard
I have a splash page and Id like to add a button that will take me to a excel sheet. Is this possible? I cant import the excel sheet into access as it needs to be kept seperate so it can be edited by other people in the section. So Im after more of a shortcut link type effect. is this possible at all?
Thanks
look for the best method. I have another software to work with my access. End of each month, ProgramA will generate an excel file with the monthly data. I want to import/link it with my access. I first try to import it everytime I generate the new excel file. However, there are one line at the end of the excel file with does not match the feild requirment, and generate an error table in access saying a number field cannot have string.
Then I try the link method instead. This time, it would work at all. The first time is OK, but the next time, I guess more lines are generate than the orginal in the excel file, it could not open up. Number of columns is the same.
The best method right now is to delete the last line of the new generated excel file, however, because I am not the one using it, I want to have a better method for my co-workers.
Are there ways to import excel data except the last line;
or
Are there ways to import excel file without an error table generate
Thanks :)
I'm not very familiar with linking data from Access to Excel but I think it's what I'm going to want to do for my operation. I have a huge spreadsheet that my boss handed me and he wanted to see if it were possible to only present a part of it in access. I already have a form to a table that I created however, it came to my attention that creating a link also creates a new table so I guess my question is: Is there an easy way to have the form always correspond to the linked table? Or another question: is this the right way of thinking about linking the data?
View 1 Replies View RelatedSo I've just started with a company where my job is to manage a ton of data. I am new to Access (2010) and am completely impressed by all the awesome things it can do. However, I am running into some issues with knowing the best way to get my current data (which is all in Excel spreadsheets) into Access.
We are working with about 68 customers in 6 different focus areas (or areas of improvement). To make it easier for them, my company has not required them to enter all their data for each area into a centralized database. Instead, we are pulling reports (into Excel) from 3 different databases. The customers who are not currently submitting data to these databases are sending us Excel spreadsheets with their data (they send a seperate spreadsheet for each focus area). So you can see where my problem lies ... NOTHING is the in the same format. Even then the Excel spreadsheets look different from month to month (and customers submit a new, updated form every month with the current month and previous months) because the people managing the data before I came along changed the format a few different times and the customer has the ability to change them too.
Basically, I would really really really like to be able to just link the Excel files to my database, but I am struggling knowing how to do that with my data in so many different places and forms.
Hello,
My access skills aren't as good as my Excel skills. I am trying to convert a large uwieldy set of Excel spreadsheets into a more manageable database.
Part of my Excel sheets use logical arguments - so they interrogate a cell and if there are two of three results another cell reports 'yes', if not a 'no'.
I have set up a matching table in Access but don't know how to, if I can, get Access to evaultae a field result from data entered ito another cell.
In one cell the data entered will either be H, M or L. I want another cell to report Yes if H or M are present in the other field and 'No' if not.
Is this possible, I'm pulling my hair out and I want to get away from using Excel.
Thanks,
Fraser
I have an access 2010 database that looks after all the engine data for a fleet of engines. Each engine has a unique serial number and that serial number is displayed in a test box on a form using a search function.
Each engine serial number has a corresponding excel worksheet where the engine data is displayed as a graph.
Is there anyway that I can have a control button on the form that will allow me to display the excel spreadsheet corresponding to the engine serial number displayed in the text box?
Is there any way how to create reliable link between Excel and Access which would work reversibly? I mean, if I change the data in Access (table) they will change in Excel spreadsheet and conversely?
View 10 Replies View RelatedI am testing the security of my DB X on Acccess 2007. I could create a new database Y and linked to the database X. Unfortunately i could change the records on the tables. I don't want other DB that make connections to my DB to change my tables!
View 1 Replies View RelatedI've a database with multiple users and each user should fill in a specific textbox in a one form. there are alsow two textboxes that he needs to fill which the current date and userid.
What i want is that once the user fill in the that textbox, the datebox and userid to filled automatically.
Hi,
I would like to rename my access file. My problem: I have many pivot in excel link to this database so if i rename it all the links will be down...How can i resolve this?:confused: (of course rebuild all pivots could be a solution but I have around 50 pivots behind my database)
Thanks for your help!
Is there a way to import data to Excel from Access without retaining the link ?
I have a table and two queries (from that table) that I wish to export to a specific (Templated) Excel file.
I want to send the data to the Excel file then be able to subsequently copy and paste and email the file without any data connections etc.
Alternatively : to export from Access to the templated excel file.
I have a workbook which has links to access to import data. I have to have the information in Excel for a couple reasons:
1.) Many of our customers don't have Access.
2.) The customers use a "discount calculator" to apply their own discounts.
They also use it to then apply their own margin mark ups to be able to then use to quote to their customers. So a static report/pdf for them to look at doesn't work.
I've begun to create links from a number of queries in Access, which work fine. My problem is when I go to update the data. I'm not getting the following error coming up:
The database definitely hasn't moved. And I've run the queries in q, and there aren't any problems there. I've looked this error up and I'm seeing that it could mean that I've got some corruption going on.
Before I hit my main q, I should also note: I'm running all of this on a Citrix network. I should also note that it's a consulting gig. Once I'm done, I won't be available to fix major issues like this.
I have a question about the best way to go about linking an excel workbook to an ms access table? I have researched hyperlinks and attachments and ole objects and I am not sure what is the best option. I believe hyperlinks will be best, because the attachments will bloat the database, but I am not sure how to go about doing that in vba? My process is such:
1)Users enter project information
2)Users enter the sample information for each project
3)The project and sample information is combined by a query
4)The user clicks a button to print forms, which runs the query and opens an excel workbook template.
5)The data is exported to a specific sheet in the workbook
6)Using vba in excel, the data is used to populate cells in different sheets depending on critera.
After all of this is accomplished, I need the user to SAVE AS the excel workbook and it needs to be "attached" to the ms access 'project' table. I am not sure what is the best way to link this back to the database. I would like to automate it with vba if possible.