I am working on automating a rebates system we have here in access. I need to figure out a way to get access 2000 to automaticly delete some tables and then import new ones at the begining of each month. I am very desprate right now so any help would be greatly apreciated.
View RepliesI have 2 identical database in terms of structure but it differs in data.
Basically I would like to import data from subDatabase to mainDatabase and ensuring that there are no duplicate records.
I have used the "link to datasource method" through importing the tables to have the "updating" function.
However, this method also means that the records in mainDatabase are also imported over to subDatabase which I do not want.
Is there a method to ensure that the records are shared/update one way only? (i.e. import from subDatabase to mainDatabase and not main to sub?)
finding some way to import my tables from excel into access 2007 with comments still inside their boxes.
one of the columns in my table is called "Order No" and each field contains a Comment as a note to go with the order.
Is there a way to keep this setting when importing the tables into access 2007?
I developed an access2003 program and I made .mde file from it. It works fine and no one can access the tables. BUT when the user creates a new DB in Access and imports from my file then he can have all the tables.
View 6 Replies View Relatedhi,
Is there any way i could import EXCEL worksheet into an existing ACCESS table programmatically; like using ASP code.
Something like, i could upload a EXCEL file from a browser and then it can be imported into an existing table.
And if possible also check for duplicate keys and update those records. If no records exist then insert them.
I really need this, because the users get loads of worksheet data to update.
Please do help
Hi guys
I've been given a project at work, part of which involves importing parts of a very complex SQL database in to an Access 2002 database. This is very much on the edge of my understanding of databases, so please bear with me!
All of the records I need to import are in one table, but some of the fields are linked to other tables in the SQL server. My question is, if I import the table in to Access using Get External Data/Import, will the information from the linked tables also be imported, or will I also have to import the linked tables and re-establish the link between the tables in Access?
Thanks in advance for any advice
--
moto
Hello everyone,
How can I transfer or import data (NOT TABLES) from two related tables. The two tables have parent-child relationship and have multi fields. I tried to use the import command but it imports tables rather than data. but I want to move data not the whole table. I can use copy and paste command but I couldn't copy both main data and sub data at the same time. I could be able to copy the main data all at once and paste them but they don't take the sub records along with them unless I copy them record by record and pate them to the corresponding file, which is very time consuming for a very big data.
Is it possible to create a command that imports data from two tables at the same time? Note that these tables I am trying import data from have the same format but different field names.
These data are collected using the same application but by different users at different locations and I want to transfer them to our main data base. If any of you can help me with this I really appreciate. Thanks.
Girma
Hello Access giggks,
I here attached Acess db and Excel file shows my db structures for you to see and be able to help me out. All I want to do is either to create a command or query to import file from two different tables which have parent-child relationship from a different folder to my current db of similar tables (except for different field names), which is the main data storage. I, therfore; ask you to help me out resolve this issue. I know that someone offered me an help last week but asked me to give him/her more information. Here they all are attached to this email except for some field names. I omited them out to reduce the amount of data to the limited amount. Thanks for your help.
Regards,
Girma
I get the following error in both blocks of code: Field 'F1' does not exist in destination table <myTable>
Code:
Private Sub ImportFile(strFullFile As String)
Application.SetOption "Confirm Action Queries", 0
Application.SetOption "Confirm Document Deletions", 0
Application.SetOption "Confirm Record Changes", 0
DoCmd.RunSQL "Delete * from do_not_call'"
DoCmd.TransferText acImportDelim, "", "Do_Not_Call", strFullFile, False
[code]...
I'm trying to perform a massive data dump. I have about 1,000 records that need to be added into my database. This is coming off an Excel spreadsheet.
I don't know if this is possible:
I have a table, tblTorders, which is linked to the table, tblItems.
When I open the tblTorders, I can click on the plus sign to expand and see the related data in tblItems.
How can I import data to populate the fields in both of these tables? I can't use the import function because you can only select to import it into one table.
Do I do it through a query.... I'm not sure where to go on this one.
Thanks so much
I have an Excel spreadsheet of data, that matches fields with two different (many-to-many linked) data tables. Can i import then separate the data into the respective tables, while maintaining the relationships created by junction tables? Or can I create a query to temporarily link the two tables and their related fields, input the data, then disseminate it to the two separate tables??
Thank you all for your input as I fumble my way thru this!
When i try to import data from an excel file to an existing table in MS Access database i get a pop up saying "Access was unable to import data". When i click OK it says "finished importing data" .But when i go to the table there are no new records added. Can anyone please help me with this ? All the fields in the excel file are as they are in the table.
View 1 Replies View RelatedI have a project concerning lists of external files. The spread sheet holds the source data on a document per line basis. Each row contains vital data ClientID, ClientName, DocDate, DocDescription, MainPage, Page1, Page2, Page3.... up to Page 585
I have done previous work where importing up to 50 columns has never been an issue.
For some reason in this case I am unable to import more than up to 255 columns and also I lost all the reference data past column 30.
I have tried importing directly to a SQL Server Db - same issue
Access 2010 and this in 2013
I've got a problem I can don't know how to solve (since I'm a complete access noob). I've got an acces table that is populated with around 1000 entires, all starting with letter N, followed by numbers. Then I've got another table from last year which is also populated with 1000+ N entries AND 1000 V entries.
I would like to trasnfer/copy all V entires from last year table into this year table. I'm sure this is possible but I don't know how. In short, I would like to copy 1000 rows of last year data into this year table/data. What's the easiest way (if there is any)?
I am trying to set up an access button to go to a website, download its source code and import that txt file into a table so it can be parsed. Well, when I go to import this text file, it imports that data in a weird inconsistent order. The problem is I need the order to read exactly how it is from top to bottom, since the numbers I'm parsing from the code need to correspond to an XL Spreadsheet (which also gets imported).
I have the code set up, and everything is doing what it needs to do perfectly, EXCEPT this import. I know it's something stupid, but I just don't know what! I have everything being imported into a text file with an arbitrary delimiter that doesn't appear anywhere in the source code. Is there a way I pull this code in line by line in order into one field with X amount of rows so I can just run queries to pull the numbers I need?
I am trying to write some code to import an excel table into access. I want to delete and append a table already in the database. I am having trouble writing the code to do this. If this is at all possible through excel, I would prefer to export the table from excel into access. Otherwise if that's not possible, a macro to import from excel will do.
View 5 Replies View RelatedI'm fairly new to Access, but have set up a database containing 8 normalized tables. I would like to know if it's possible to update all those tables by importing an Excel file into each table, or importing the Excel file into one Access table and then appending that table to those 8 tables. AND STILL MAINTAIN THE RELATIONSHIPS. The Help directory only talks about importing or appending into one table.
View 7 Replies View RelatedCan you import from a .txt file on Notepad into an Access table or will it have to go via an excel spreadsheet to begin with?
View 1 Replies View RelatedHi All,
I'm trying to import information from an xls file into an Access database.. I understand how to use the File --> Get External Data --> Import option in Access, however I only have the option of importing the information into Sheet1, Sheet2 etc
I already have a table named Info1 which I want to import the information into
Can anyone advise how to go about this
Thanks
how to import data from excel 2007 like' suppose the field in DB table is A, B & C and the same is there in excel 2007, now i like to get B & C filed data from excel to DB table directly (import) which may be through button at form, because i have given my user the accdr file so they cann't go into the table and paste record.
View 1 Replies View RelatedI have a spreadsheet of generators with associated data: Make, Model, etc.
When I build the tables for the Make, each make will have it's own PK. Is there a good way to update the spreadsheet, replacing the Make for the PK other than using the find and replace function in excel (or update query in Access).
Example:
tblGeneratorMake
GeneratorID (PK)
GeneratorMake
John Deere has PK of 1
Kohler has PK of 2
If my spreadsheet has a list of Kohler generators, I need to change "Kohler" to "2".
I am importing information into a table from excel. The number is formatted correctly in excel and is displayed as 10309976464180, but when it is imported into access it displays as 1.030998E+13. I have tried all of the possible formatting for numbers but nothing corrects this, and if I change to Long Integer it actually removes the numbers. What is the correct formatting in Access to get these numbers to display correctly?
View 2 Replies View RelatedI am building a database for a coworker. For one table, he'd like to extract data from different companies' financial reports, specifically a Schedule RC-B (schedule of securities). The format it comes in is PDF, but there are options to download XBRL, SDF and Taxonomy. My computer doesn't recognize any of these other formats. Plus, I'm guessing each company will have a slightly different format, so I don't know if there'd be an efficient way to set up an automatic import. Any way for importing/extracting data from these files?
View 2 Replies View RelatedI have a csv file with one row containing delimited text via a comma
Example
1, James, Smith, Manchester, email, telephone, notes etc..
Think there are 50 comma separations all together. Anyway when I go to import / link my csv into access the data that is on the first row should it create individual fields where a comma has been placed... But it has doesnt quite worked, some of the fields are created and the rest have been put on a separate row! Rather than going to a new field. Rather having 50 fields I've got 21 fields and 3 rows or delimited text...
I have a table that contains about 75 fields. Each field is going to be a Lookup field that will allow the user to enter multiple values. This is for a home inspection service. So the first field name will be ExteriorShingles. The user clicks the dropdown arrow, and is allowed to select multiple values such as "loose", "missing", "rotted" etc... I was wondering if there is an easy way to import all these values from my Excel spreadsheet, or do I have to enter each one individually, which is going to be a lot of work.
View 2 Replies View RelatedI am building a small database to automate the process of producing sales reports for our sales staff using data from our customers (distributors). They provide us with Excel spreadsheets with detailed sales data for our brands at THEIR customers (retail stores).The problem is that many stores receive from two distributors, and each distributor of course has different "customer numbers" for the store. I've built the database with the following:
tblStores (containing the list of stores)
StoreID
Distributor1StoreID
Distributor2StoreID
Distributor3StoreID
tblSalesData (containing the monthly sales per store, by brand)
StoreID
Brand1Sales
Brand2Sales
...
etc
When the distributor provides the spreadsheet, they use their Distributor1StoreID (or 2 or 3, depending on the distributor). I want to import it to tblSalesData but would need to lookup the StoreID from the tblStores during the import, using Distributor1StoreID, etc.