Importing Additional Data
Sep 19, 2005Can I import data into a table that already has data in it? I want to add this new data to the existing information.
View Replies
ADVERTISEMENT
Modules & VBA :: Importing Excel Files - How To Add Additional Columns
Dec 31, 2013I need to add two additional columns for each imported spreadsheet, which are not in the original files.
First column, named 'Customer Name', needs to retrieve information from cell A6 in Excel file, which is not part of range "name" that is imported to Access. If necessary, I could somehow include it in this range but then I still would have a problem of how to repeat a value of A6 in each row of table in Access.
Second column, named "File Name", I would like to include an Excel file name from which data was imported. Again, I would like to repeat value for each row in the table, i.e. if I have 6 rows with data from file X, I would like to repeat X.xlsx in each row in column "File Name".
Code:
Dim strFile As String
DoCmd.SetWarnings False
DoCmd.RunSQL "DELETE * FROM Data;"
' Set file directory for files to be imported
strPath = "C: est"
[Code] ....
Add Additional Number To Data
Oct 15, 2007I have a table column with fixed data of "ABC-123" and need to add a zero to the number like "ABC-0123". How can I do it to all the data? Thanks.
View 2 Replies View RelatedHow To Link Additional Data Source To A Form
Mar 22, 2006Hi All,
I have a db with three linked (related) tables. I have a form that has, at present, only one of these tables as a data source. Now I want to bring a couple of fields from another table into that form.
I know how to link a table to two data sources when first creating a table. But how do I do it when the table already exists?
I tried Table Design View | View Properties | Data source,
but that allows only one data source. If I link to another, the first disappears.
Thanks.
Adrian
How To Link Additional Data Source To A Form
Mar 22, 2006How to link additional data source to a form
Hi All,
I have a db with three linked (related) tables. I have a form that has, at present, only one of these tables as a data source. Now I want to bring a couple of fields from another table into that form.
I know how to link a table to two data sources when first creating a table. But how do I do it when the table already exists?
I tried Table Design View | View Properties | Data source,
but that allows only one data source. If I link to another, the first disappears.
Thanks.
Adrian
Reports :: Save Additional Data From Report To XLS
Oct 25, 2014I have a form where user can chose his own criteria for the report, like time period, ppl involved and other parameters. i open report filtered with these conditions. I also create a nice text (as public variable) bout what where the search criteria and put it in the header/footer. Then I export the report as xls file. it's nicely saved as column names and data, just what i need.how to add a field that would store the criteria, ie that string public variable that has it all neatly explained?
View 1 Replies View RelatedReports :: Getting Additional Data As Well As From Query / Table
Nov 28, 2014I have a report which is bound to a query.The body of the report comes from the query.I also have additional data that is displayed on the form that is currently 'hard' coded into an a label.
I would call this data reference data. It's not specific to a client so there is no logical place to store it other than a reference table which will have no links to other tables. ie it's not truly relational. can I get data from this reference table in the same way I could do on a form by using a combo box and having a SELECT statement?
Tables :: Calculate Some Additional Data And Generate Quotations - Too Many Fields
Jun 2, 2015I have a database that will take lots of data entered by an employee and calculate some additional data and generate quotations. Within each quote there is a possibility for 15 different metals (5 Precious Metals, and 10 Base Metals). There is also 5 fields that need to be filled out about each Metal (What the metal is, the market being used, weight, whether it is included in a different price, and the price). I currently have 75 fields to address each Metal and their 5 fields respectively. Is there a better way to Normalize this data, and accomplish what I need accomplished? I want at the form level the employee to tell the database whether they want to add a Precious Metal, or Base Metal, or Move on to other data entry.
Here is a Screenshot of the design view of one of my tables with too many fields : table screenshot1.PNG
Queries :: Extract And Replace With Additional Data Append Delete Query
Jul 1, 2015I have a Table1 served by Form1..It is a list of: UnqID, process, quantity, totaltime(in seconds).I want to click on a record to bring up a filtered Form2 with the chosen record on it.What I want to be able to do is to now split the quantity (and the time) and put these new records back into Table1 and delete the original record
EG
ID1,10,write a report,2400
I want to delete this and replace it with two (or three/four etc) replacements, but still adding up to 10 quantity and 2400 seconds so that the new data could be:
ID2,5,write a report,1200
ID3,5,write a report,1200
My initial thoughts are to create a holding table to:Append filtered data on Form2 to a holding Table1hld (i don't know how to do this) delete data in Table1.then enter the new quantities into a holding Table2 (that I will input myself) and then append (through a series of queries back into Table1).The first problem is how to append (and subsequently delete) the filtered record from Form2 to Table1hld.
Importing Data
Jun 6, 2006I'm using a combo box control for searching employees. Which the empID is the unique key, the form is scrolling each record, do not want it to do that. When i click on an ID, it only changes ID's but not the information thats tied to that ID. How can I fix that? any valuable information is well appreciated. Thank you
View 3 Replies View RelatedImporting Data
Jul 16, 2007Someone recently answered my query with regards to uploading data to an access table.
The first coloumn is an auto incremented number.
Will there be any problems with importing data - when one field is auto increment?
Obviously I wont be uploading values for this column - can that be done?
Help With Importing Data
Nov 14, 2007Hi,
Another question on this database I'm working on.
I have my database pretty much ready to go, but they would like to import data from another access database into this one.
The problem I'm seeing is, I've been working so hard to normalize my database with the proper relationships etc.
The database I'm importing from, the data there are all stored in huge tables.
so for example in my database I have our main table, that holds all like data. Then my other tables for specfic data that then relate to the main table ID.
The other database has everything in 1 table.
I've created a query and got what I needed from the other database, but not sure how to import it into my main table, and have it so the 'specific' data goes into the right table, and so the Main_ID field points to the correct record in my main table.
I don't think I explained that very well.
Here is how my structure is in the new database
tbl_main
Main_ID
Code_ID
Effective_Date
End_Date
Createdby_ID
tbl_CCE
Main_ID
Codeinfo
etc
etc
now the old database, everything is in 1 table and I'm not sure how to break it down so after I import the table CCE/Main_ID is the same as the Main_ID in my main table.
I'm still not sure if I explained that very well....
Importing Data
Aug 10, 2005Hi
I'm trying to import data from an Excel spreadsheet into an empty table using the Import Wizard (File/Get External Data/Import). All's well until I'm presented with the window that tells me that I can "store" my data either in a new or existing table. However the radio button and Existing Table name field is grayed out. Any ideas gratefully received.
Baz
Importing Data Help
May 15, 2007I'm hoping someone can help me with what (I think) may be a minor oversight by me.
I'm trying to import data from an Excel Spreadsheet into a table that I have already created for my job.
Both the table and the excel spreadsheet have a common factor which is an identification number. I would like to import the data into the existing table so that the additional values fall under the appropriate identification number.
I hope that makes sense - if not let me know and I'll try to explain further.
So my question is - is this possible? I searched the help files and some internet resources and couldn't find anything this very specific kind of importation.
If anyone could help me I would greatly appreciate it as you would save me tons of time.
Thanks in advance!
Importing Data From Mde
Feb 18, 2008I have my sister using the db (in mde form).
When I make design changes to the mdb, I need to import (freshen) the data from her mde. (We're in different states) Obviously, when I do this, I get a duplicate table renamed.
If I do a query to freshen the data, will an update query just copy the changed/new data without the unchanged ?
Or is it best to just delete everything in the table and append the data from the mde table ?
Or is there a better way to do this that I'm not thinking about ?
Data Importing
Feb 18, 2008Hi everione
I have to make a db that imports data from a textfile. I read the posts about automating the proces but I have two other problems. The text file is generated by a proces control software and has a .gbc extension ( I tried to solve this by importing to excel and then to acces) and the textfiles has a limited number of entries araound 300 so after al the records in the textfile are writen the records are overwriten. Is it posibel to make acce to read only the new records and adi it to a table witouth deleting the old records? the record has a date and time included.
Im a acces user for only two weeks so i would be greatful for any help.
Importing Data
Sep 11, 2006HI I would like to design a form where user could be given an option to browse a database .mdb file and then select a table from that database that appears in a combo box and then a query should retreive all values from that selected table. I have tried with recordsset thing but error comes as Type Mismatch for
Set rs = Currentdb.OpenRecordset("strqry")
or when i tried using application.access thing. I still could not retreive list of tables. Thanks very much for suggessions that I am looking forward to.
Cheers
Abid
Importing Data To Back End
Jul 25, 2005Hi,
I have a DB that relies on text file imports as well as input and I recently split it. Unfortunately now my refresh script that updates the tables based on the text files imports them into the FE rather than the BE. I have messed around with workspaces but am struggling to get a solution. Ideally i'd like to be able to call DoCmd commands directly in another database but if anyone could give me the code to execute a function I can take it from there.
Thanks, Tom
Importing Execel Data
Aug 9, 2005I need to import a named range of cells form Excel 5 worksheet into an access table. I was hoping to get some sample code I could modify for my own project. I have already looked at the sample cosde that came with Access. It has been no help for me.
View 1 Replies View RelatedImporting Data Between Databases
Aug 24, 2005I have searched and not found exactly what I am looking for..so here is my question.
I have a large database that works fine, IF people would stop trying to play in it!! What I want to do is to restrict access to everyone except managers.
So, I copied the db for warehouse users to input their data (picker id, no. of minutes) that holds only one table and the form that opens automatically (they do not have access to anything but the form) for their input...Then, at the end of shift I want the managers to be able to click a button on Switchboard that copies all entries for day into the original db to run their reports. (These dbs are on a network)
So, how do I manage this? I want to use a macro and transfer database table, then run an append query to put the current records in original table...I can do that, but I dont know how to delete the records in users db. It needs to clear out all records in that db when it has been transferred... I want all control to be in managers hands. All the users can do is input their data.
I know you can help, so I will say thank you now.
Importing Data From MySql
Apr 5, 2006Hi,
is there any other way to import data from a MySql database then via MyODBC I'm experiencing quite some problems with it (v3.51.12)? , especially with character coding...
thx
Miha
Importing Data Question
Apr 19, 2006i have a data file that is formated similar to this
A1111222223333344445555
B2222211115555444433333
i need it to be automatically imorted to a data base in the same order but each row formated the same such as:
A1111222223333344445555
B1111222223333344445555
any idea how i could do this so every time i imort a file like this that it would format automatically?
Importing Data From Excel?
Dec 5, 2006I need to import 1600 people from excel.
as the program that we use to use was free and setup for what we needed. That has the ability to create a excel sheets with the 1600 people on.
Now all the fields are different, and i'm not sure how to do it.
When importing do you get the option to put the fields in the correct place, or do i need to edit them? and then import.
Another thing the address layout with fields will be completely wrong. I believe it used separate fields for each line of the address where in my DB i use 2 fields 1 address and 1 postcode.
Importing Data From Excel
Apr 15, 2007Hi,
I am trying to import some data from excel to a new table in access. When i am running the import wizard in access i.e. File->Get External Data -> Import, as soon as i select the excel file (which has a sheetname of Sheet1), i am getting an error that i can not import since there is an invalid character 'Sheet1$'.
I tried renaming the sheetname to various other names, however, everytime i am getting the same error with the dollar sign being added at the end of the sheetname.
Any ideas what's going on please ?
Thank You in advance.
Importing Data Into Access
Aug 29, 2007how to import text file row by row into access?
pls help me out......
Importing Excel Data
Jan 28, 2008I am trying to import Excel data into an existing Access table. I keep my Excel spreadsheet in the same format as my Access table and when I import data that attaches at the end of my Acess table it works fine.
But I am now trying to import Excel data into the same existing table into rows that had cells left blank for entry later?