I am Oracle Guy & new to Ms-Access. I want to load the data from Ms-Exell into Table in Ms-Access automatically through Procedure / Macros. How to do this process?. Help me, if anyone knows.
Regards,
GKS:mad:
I have converted 6 Excel spreadsheets to one CSV text document distinguished by their sheetnames. Where I am stuck is trying to import that CSV file into 6 separate tables in my Access database. Does anyone have any ideas how to do this using VBA. I am still a newbie at this, so any help would be appreciated.
View 1 Replies View RelatedHi all,
I have an access mdb file and just added a new field to one of the tables.
I also have several spreadsheets with bits of information that I would like to use to update the newly created field for each record.
Not sure what is the best way to approach this. Can I use a query that will look into the spreadsheet and copy the specified cell to the newly created field using an if statement? or
Do I need to get all data into a table and upload as a new table in Access then use query to update the records?
Please keep in mind that I do not wish to append new records, I need to update existing ones.
The above represents my thoughts on how to approach this task, I would appreciate any help.
I must also state that I am totally new to access and would appreciate as much detail as is possible in the response(s).
Thanks,
Wingale
I have uploaded data from excel to acces and found some data issues in columns in Acess tables.It has '?' mark in some data in the filed.This is mainly becuuse some excel cells got carriage return in the cell. Can I fix this issue strightway in access column without update excel to remove space and carriage returns in there and then upload again.
View 2 Replies View RelatedI am working on a project where I need to upload selected data from multiple sheets of an excel file. Here is an example of what I want.
1. I want to create a table in Access with around 10 columns
2. Column 1 should be populated with the date field found in A2 cell of sheet 1 of the excel file
3. Column 2-5 should be populated with the columns B2-E200 in sheet 2 of the excel file.
4. Columns 6-7 would be populated based on values from columns 1-2 of the table. Basically Column 6 should be Column 1 date plus 60 days.
5. Column 8-10 would be user generated after the excel is imported and the user should have the ability to attach around 5 files to each row.
I have a excel file and want a button in the sheet which would transfer a certain range of data in a defined excel sheet to an existing access db table. How to do about doing that.
View 5 Replies View RelatedI am working on a project where I need to upload selected data from multiple sheets of an excel file. Here is an example of what I want.
1. I want to create a table in Access with around 10 columns
2. Column 1 should be populated with the date field found in A2 cell of sheet 1 of the excel file
3. Column 2-5 should be populated with the columns B2-E200 in sheet 2 of the excel file.
4. Columns 6-7 would be populated based on values from columns 1-2 of the table. Basically Column 6 should be Column 1 date plus 60 days.
5. Column 8-10 would be user generated after the excel is imported and the user should have the ability to attach around 5 files to each row.
I cannot seem to find a way to upload several rows of data to one column in Access!I have about 9 columns already in the table which have 900 rows each. These include names, numbers, address etc.I was asked to add a column on next to the 9 columns with corresponding User ID such as 0093457FX (Which I really do not want to add manually).Every time I try to upload an excel file the data either goes below the current data from the 9 columns on the new column and does not match the current data set, or it does not show up at all.
View 4 Replies View RelatedI have one DB that is used for creating/storing customer ID's, and another DB that is used for creating/storing job information for customers.I have linked the table from the customer DB to the job DB.
There is a table in the job database that holds customer name and ID, and some VBA that generates unique job codes.
Is it possible to have the data from the linked table automatically update into the existing table?
Hi All,
I have an existing database in access now I need to add records (10000 rows) in this table from excel. When I try to do an import from Excel to Access it gives me an error.
Please Help!!
I am pretty new to access and have created a pupil details table which contains: Unique pupil Number(PK), Full Name, Date of Birth, Teachers Name and want those details to populate another table when requested. The secondary table looks up the Unique pupil Number and i wanted the same details in the second table to fill themselves. The Unique pupil number in the second table is not the Primary key and allows duplicates, which has allowed me to create a one to many relationship. I fill the Unique Pupil Number in on the second table via a combo box but am unsure how i get it to fill in the other details on the second table. Can anyone help please???? :confused:
View 5 Replies View RelatedI am working with a table where I want to be able to add choose the customer name from a dropdown and have the customer number automatically populate. I set up the dropdown already using the query builder for customer name and it works perfectly. I also chose customer number in the query, but it does not show.
Even better, in case of duplicate names, I would like to be able to select the customer number and have the name populate.
So ultimately, when I select either field, I want the other to auto populate...
Could anyone explain me the best way to fill external HTML pages automatically with data from an Access dbase?
I have spotted several commercial tools that use macro recording. Surely there must be another way using visual basic for example?
Hello Everyone,
I am having trouble with our receiving database. This database consists of two tables. One for vendors, which basically contains their vendor ID as well as vendor name and phone # etc. The other table is our receiving data table. When our receiving person receives product in, they log this in the receiving table including info such as date, autonumber for record, vendor etc. The problem is, when the person selects the vendor id, which is set up as a lookup field, we would like to have the vendor name pop up atuomatically within that record. I cannot for the life of me figure out why this isn't happening. The person is using a form to enter all of this data and runs a summary report at the end of the day. Our accounting dept. is requesting this info be added, but I cannot seem to figure it out.
Thanks so much for any assistance!
Amy (monet1369);)
I have 3 tables:
Student Info:
Student ID (Primary Key)
Name etc.
Assignment Info:
Assignment ID (Primary Key)
Assignment Number
Criteria Number
Grades:
ID (Primary Key)
Student ID - Linked to [Student ID]
Assignment ID
Criteria Number
Grade
What I would like to do is be able to link the tables in such a way that for each student entered in the Student Info table, entries are automatically entered into the grades table for each assignment criteria.
For example:
Assignment 1 has criteria 1.1, 6.3, 7.2, Assignment 2 has 4.2, 3.3
When John Smith is entered in student info, the grades table is automatically updated with 5 new entries in the form:
John Smith - 1 - 1.1 - Enter Grade
John Smith - 1 - 6.3 - Enter Grade
John Smith - 1 - 7.2 - Enter Grade
John Smith - 2 - 4.2 - Enter Grade
John Smith - 2 - 3.3 - Enter Grade
That way I can have a form that automatically shows the possible criteria for each assignment on the sub form for each available student without having to type it in each time.
Your help would be wonderful
I have a Macro Which my team members fill and submit the information of their daily workload. And the person who Submits has a Pivot table to check if the Workload that he has submitted has been QCed or not.
I have made 2 Tables one is temporary database and other is a master Database, I keep clearing the Temp Database because when users refresh the Pivot table it takes less time if there is less data and Vice Versa.
Problem Statement: When a particular Column is updated for example "QC Result" column is updated as "Green" or "Red" the entire column needs to be moved to the Master Table.
How to use VBA..... I have set up a simple database to enter data into then upload to a client web portal.
I have a form to enter the data and the table this data goes into has a check box at the end which I want to have ticked/checked/True after I have exported.
I have created a query that shows me all data that is unchecked (not yet exported to an xls)
I have created a simple export macro that sends the query result to an .xls
I want the macro to finish by checking the "export" checkbox once I have done this....
I am using Access 2010 attached is a screen dump of what I have so far....
I'm trying to upload a csv file into an Array then add records to a table. I have the following code which gets the information from a csv file which works fine.
Open filePath For Input As #1
Do While Not EOF(1)
Line Input #1, MyData
Problems:
1. When i try to load this into an array , it does not return all the information. It will if a smaller amount of data is sought. For example if only 1 months month of data is requested. Is there a maximum data limit that can be parsed into an array with this method?
2. I'm not quite sure how to parse individual lines (records) to update a table in access. I have provided the code that I'm trying to use to accomplish this below. From code below am I doing this correctly?
3. For each record that is created in the database I would like to add a ticker string to the record for later querying. Can this be done and am I on the right track from the supplied code?
Private Sub ImportData(filePath As String, ticker As String)
'On Error GoTo Errorhandler
Dim arrData() As String
Dim MyData As String
Dim i As Integer
Dim Db As DAO.Database
[Code] ....
A field in a table can be populated by a lookup up but it has to be done manually or with a form.A "new" table can be created with a query that matches the data.
Is it possible to skip these steps and create a field that automatically populates with the data from another table based on other common data?I can do this in Excel but not sure it can be done in Access.
I have a form and table called pcinfo-vendor that the customer enters some date that they need. They also need to pull up some vendor information from a table called vendorinfo Vendor name, Address, City, State, Phone #, FAX # and Email. How can I bring up the data from the vendorinfo table on to my form called pcinfo-vendor? So that the customer does not have to type in - Vendor name, Address, City, State, Phone #, FAX # and Email each time for every vendor.
View 1 Replies View RelatedI have a table with 715K records. Each record is an inventory product, and the sixth field of each record is a short description. The tenth field is a single-letter category designation, and is currently blank. What I want to do is search through the description field of every line, and where the word "Paint" is contained, enter a letter "P" in the category field.
View 2 Replies View RelatedI'm on my way on creating a simple Database for a company. This database contains several tables, one of the tables will record information about the training that had been completed by each employee. There are about ten sections of training that should be completed.
For instance, I have two tables called 'Development' and 'CSA_Lisence'. 'Development' is the table that record the information about training which containing ten checkboxes (which represent ten sections of training) and CSA_Lisence will be automatically requeried when all of the checkboxes on Development are fully checked.
Here's the step I've been worked on :
First, I made a function called 'CheckCompletion' to ensure whether all the checkboxes are checked :
Code:
Public Function CheckCompletion() As Boolean
Dim blnComplete As Boolean
Dim strCompletionSummary As String
strCompletionSummary = Basic_Inspection & Certifying_Staff & Safety_Management_System & Regulation_Part_145 & Part_M & EWIS & Fuel_Tank_Safety_Level_2 & Dangerous_Goods & Human_Factor & Basic_Supervisory_Training
[Code] ....
Second, I made a function called 'UpdateEmployee' to handles if all boxes are checked :
Code:
Public Function UpdateEmployee()
Dim emp_numb As Long
Dim emp_name As Long
Dim strsql As String
emp_numb = [Forms]![development].[employee_number].Value
[Code] ....
Then, I put this code on every checkbox's after update event (example only) :
Code:
Private Sub Basic_Inspection_AfterUpdate()
Call UpdateEmployee
End Sub
The problem is, nothing happened with the tables. However, when I managed to remove the 'If checkCompletion' condition, it worked and the 'CSA_Lisence' is requeried, but I will have ten multiple records with same contents (I just need one record per employee). I guess there's something wrong or missed in my code. Or i need to remove something?
I just created a database and need to connect it to the data source. The data comes from a http website (intranet from work). When I open the link using firefox, I can view the website with the data in it, but when I open it from Internet Explorer, I get a save as pop-up message to save a csv file which contains all the data. The extension of the http website ends with csv. So it is something like http (slash slash...) Intranetname/referral_dbase.csv
Currently, I am opening the file using firefox, copying all the data manually, and pasting it in a text file using notepad. After that, I import the file into access. The delimiter of the data is this symbol: |
I am trying to find a way to link my database to the website where the data is located so that I can skip the manual process of opening the website and copying the data and saving it into a text file and then importing that file into access. I was thinking to have like a form in access with a bottom that will automatically import that data from this link and paste it into a table in access using the delimiter symbol mentioned above.
Is this too complicated? Is it even possible in access 2010?
Hi Folks,
I have created a file sweeping program in Microsoft Access via VBA in a few modules. The program simply reads certain files in certain directories, and determines if, when, and where to copy those files based on certain user inputs.
One of the features I would like to add would be to upload the files that meet that criteria to a conventional FTP server requiring a username and password. However, the last few days of research all tells me that it is not possible to perform FTP functions in Microsoft Access or in VBA.
I am just wondering if that statement is really true? I figure the worse case is that windows has its own version of FTP.exe that you can execute in a DOS window ... would one be able to perhaps create a command line execution via VBA? Any simple ideas or is it not worth the trouble trying to FTP upload some files via Microsoft Access with VBA?
Thank you very much,
Joe
I am attempting to split my Access Database and will upload the back-end portion to a SharePoint site. No matter what I do, I continue to get a "Not a valid file name" error.
View 1 Replies View RelatedI'm trying to create a system where if I enter data into one field it will automatically appear in the corresponding field in another table. For instance if I enter the values 10,12,15 into a field called QID in table A I would like this to appear automatically in a field called QID in table B. Both tables are related and I have enforced referential integrity and 'cascade' options but this still doesn't seem to allow one table to automatically update another. My ultimate aim would be to have a form that you filled in data for the field QID once that then propagated to both Table A and Table B.
View 2 Replies View Related