Importing .csv Or Deliminated Data Each As An Individual Record
Mar 9, 2007
Man I thought this would be simple, but it quite clearly isn't!
I have a .csv file that contains around 250 email addresses. I simply want to import these into an Access table, each email creating a new record!
NO using the import function only seems to allow you to import data as long as each separate piece of data is on field in a record! I understand whent this might be the case, but why the hell can I not import it so each piece of data is a separate record in the table!!!!!!!!!!!
Please note I understand some sort of complex query may do it, but I am not that experienced with that yet and so don't know how it's done!
Please can anyone offer a simple solution? From where I am sitting, there does not appear to be one!!!!
View Replies
ADVERTISEMENT
Mar 9, 2007
Man I thought this would be simple, but it quite clearly isn't!
I have a .csv file that contains around 250 email addresses. I simply want to import these into an Access table, each email creating a new record!
NO using the import function only seems to allow you to import data as long as each separate piece of data is on field in a record! I understand whent this might be the case, but why the hell can I not import it so each piece of data is a separate record in the table!!!!!!!!!!!
Please note I understand some sort of complex query may do it, but I am not that experienced with that yet and so don't know how it's done!
Please can anyone offer a simple solution? From where I am sitting, there does not appear to be one!!!!
Thanks.
View 3 Replies
View Related
Mar 12, 2014
I inherited a defective Access 2010 and am now attempting to import a RECORD consisting of fields of xls data.
I am attempting to import from an existing Form Datasheet so that it overwrites (or appends the new data to the datasheet) from another identical Form Datasheet because it contains an additional 1000 contacts in it.
I have resulted to Using an .mdb file from over a year ago because the current .mdb keeps hitting "The Microsoft Access database engine could not find the object (Error 3011)"
My initial opinion is that the more recent .mdb it is corrupt.
View 4 Replies
View Related
Jul 5, 2013
I have been tasked with importing data from a clocking on system to analyse worked hours.
There is no option to amend the format of the export which is not great
surnameforenameField2Field3xxx
xxx
11/06/201319.18
xxx
xxx
11/06/20135.37+
xxx
xxx
12/06/20135.41+
xxx
xxx
12/06/201319.21
The plus indicates a night shift worker
eg started at 19.18 and finished at 5.37 on the 12th
so for every record I have staff id , date, and clock time ( I have stripped out the + ) and created a yes/no field to identify the records where field2 should actually be field2+1
I have sat in query design screen for ages and cant think how on earth I am going to calculate hours worked for a given staff member and date combination.
for every combination of staff id and date there should be 2 records - a clock in and a clock out
I thought about creating new fields clockin and clockout but struggling to see how I can link the 2 "paired" records together
vb script with dlookup for every record ?
View 10 Replies
View Related
Jan 8, 2015
I have a database where I record grades for my students. I would like to create a macro so that every time I record a grade as an "F", the student will receive an email that will contain an attachment of their scores. A lot of the information I want to include in this email is in several different tables. So to make it easier, I have created a query that lists the following:
Students name (SName)
Student's email (SEmail)
ID# of the form I use to record their grades (ID)
ID# of the studen'ts work (WorkID)
Date of their work (CreatedDate)
Date I graded their work (AuditDate)
Grade="F" (Accuracy)
How can I create something that will automate emailing of this information--to the individual student with only their information? I am using Access 2010. If I can't automatically send the emails, I would like to create a button in my audit screen that will send a report containing that student's information to them.
View 1 Replies
View Related
Feb 3, 2014
I have created a database that generates a report with customer debts. I have a lot of customers and in a report each page is a different customer with individual debts info. What i would like to do is to create a button and distribute individual report page as pdf to individual customer by email. I'm using Lotus notes. I have searched the forums i found something but it was not what i was looking for.
View 1 Replies
View Related
Jan 28, 2005
I have a continuous form based on a query. I would like to have a button or control that performs some command on only one certain record. In other words, the user sees the record he wants, clicks a button and it changes the value or changes the color. When I add a button to the form, it appears next to each record and performs the same command to each record. I have tried different controls, but get similar results with each one. Even a single form seems to do the same thing, but on different pages.
Am I missing something? Or maybe I am not following the concept of the form.
View 13 Replies
View Related
Oct 18, 2005
Hi I'm a teacher and have to set targets for classes, I have created a database which allows me to input targets for the classes. I now need to then display the class target for individual pupils in a new layout. I am sure there is an easy solution and I am looking at the problem from the wrong direction. Thank you for any help
graham
View 3 Replies
View Related
Oct 6, 2004
All my records are displayed on a form. Upon clicking on their respective 'View' button, I would like to open that particular record. How can I do that? I have attached a screenshot for better clarity. Thanks in advance for the help!
Regards,
Swee
View 3 Replies
View Related
Jul 16, 2014
Not sure if it's possible but I'm trying to create individual calendar's for each staff member and client to put availability and bookings on to them. I've tried using the active x control but it's not really what I want, not sure how else to approach this as my access skills aren't that great.
View 3 Replies
View Related
Mar 31, 2014
I wanted to know if it is possible to set a rolling year based on the first recorded date for an individual. In other words, my table is updated every time an employee receives a point. The record includes the employee's name (empName), the date (dateOfOccurrence), and the point (occurrencePoint).
I would like to create a query that would be based on a rolling year from the very first record of an employee based on the first dateOfOccurrence. The first date/record of this employee would be the start of the rolling year. I am writing this in SQL in Access 2013.
View 1 Replies
View Related
Dec 24, 2013
I want to lock an individual record when a certain check box is ticked so it can't be edited again. I've tried setting the form to read only when this check box is ticked on the form OnCurrent event, but this locked every record and I had to remove the code to untick the check box and be able to edit the record again.
View 2 Replies
View Related
Sep 19, 2012
I am working on a website which has over 1000 pages that has the same code, but only a link that is different on each page. So, I thought that I will create a database and work my way from there. I was able to work the code and combine everything. Now would it be possible to export individual record from a query to a file with .html extension? If not, .txt will work as well. However, I want to have another field that would have the file names and the file is saved under that name.The query name is "Code Query" and the field name is "Final Code".
View 2 Replies
View Related
Apr 22, 2014
I'm trying to find the best way to organize a report that will have ALOT of fields for an individual record. Because it is for an individual record not a group of records (and I want it to be dynamic) I'm thinking of doing a filter & query to fill in report with necessary details. This report is going to contain ALOT of fields, even the wizard that I used based on the query said that there were too many fields, but I can't cut down.
View 4 Replies
View Related
Nov 28, 2012
I need to be able to import data from some excel spread sheet data into some individual fields of a table. Is there a way to do that assuming I have the same field names?
View 4 Replies
View Related
Aug 31, 2013
I want the lookup to be performed with criteria based off of the same row that record being selected is on.
I wrote typed out the Columns and rows that my queries return, and attached a screenshot as well.
You enter your phone number which provides you with an indexed location. Based off of that location only certain products are available and I want them to be filtered accordingly. I have it working to some extent, here is an example below:
|Site Name|Phone Number| Location |Products Available|
| Store 1 | 5044645521| KNNRLABR
The lookup displays products available where the indexed products match the same location. Here is what the query returns:
| Location |Products Available|
| KNNRLABR| Product 21 |
| KNNRLABR| Product 9|
| KNNRLABR| Product 7 |
| KNNRLABR| Product 3 |
This is the affect that I want to achieve but, if I add another location like so:
|Site Name|Phone Number| Location |Products Available|
| Store 1 | 5044645521 | KNNRLABR |
| Store 2 | 3609061624 | VANCWA01|
The lookup returns all products available for all the records for each location entered rather than based off of the selected record.
| Location |Products Available|
| KNNRLABR | Product 21 |
| KNNRLABR | Product 9 |
| KNNRLABR | Product 7 |
| KNNRLABR | Product 3 |
| VANCWA 01 | Product 31 |
| VANCWA 01 | Product 8 |
| VANCWA 01 | Product 4 |
| VANCWA 01 | Product 3 |
| VANCWA 01 | Product 1 |
Is there a way I can make the lookup run off of the location specific to the current row that I am working on?
P.S. Here is a copy of the SQL statement I'm using right now.
SELECT DISTINCTROW [DSL Product CLLI's].CLLI, [DSL Product CLLI's].Speed, [DSL Product CLLI's].CLLI
FROM [DSL Product CLLI's], [Copy Of Copy Of Customer NPA-NXX's - ADSL - Data - Internet]
WHERE ((([DSL Product CLLI's].CLLI) In (SELECT DISTINCTROW [Location] FROM [Copy Of Copy Of Customer NPA-NXX's - ADSL - Data - Internet] WHERE [Copy Of Copy Of Customer NPA-NXX's - ADSL - Data - Internet].[Location]=[DSL Product CLLI's].[CLLI])));
Which Returns the Following in my lookup field for Products Available.
View 6 Replies
View Related
Dec 5, 2013
I created a query that shows everyone who has a specific date field blank. Now want to make those names clickable so that it opens a specific form with a certain record related to that individual in the query. Each line with a different individual should open a different person on the form and their corresponding record.
View 3 Replies
View Related
Jun 6, 2006
I'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 Related
Jul 16, 2007
Someone 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?
View 14 Replies
View Related
Nov 14, 2007
Hi,
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....
View 3 Replies
View Related
Aug 10, 2005
Hi
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
View 4 Replies
View Related
May 15, 2007
I'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!
View 1 Replies
View Related
Feb 18, 2008
I 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 ?
View 14 Replies
View Related
Feb 18, 2008
Hi 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.
View 5 Replies
View Related
Sep 11, 2006
HI 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
View 2 Replies
View Related
Jul 25, 2005
Hi,
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
View 3 Replies
View Related
