The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.
One of a set of tools we're offering as a way of saying thank you for being a part of the community.
Course Of The Month
7 days, 10 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Repated data import - MS Access
Posted on 2011-03-09
Hello,
I previously asked a question about importing data from a csv to MS Access, found here: http://www.experts-exchang
During this thread, someone asked me if this would be a one time thing, or repeated.
To which I answered, one time - but I've found out since then that it will be a repeated action after all.
Someone suggested using: DoCmd.TransferText transfertype:=acImportDeli
tablename:="tblMonthlyData
FileName:="D:\Documents\Ex
hasfieldnames:=False
But I would like a step-by-step procedure as to how to do this if possible.
(Screenshots would help please)
Thank you
I previously asked a question about importing data from a csv to MS Access, found here: http://www.experts-exchang
During this thread, someone asked me if this would be a one time thing, or repeated.
To which I answered, one time - but I've found out since then that it will be a repeated action after all.
Someone suggested using: DoCmd.TransferText transfertype:=acImportDeli
tablename:="tblMonthlyData
FileName:="D:\Documents\Ex
hasfieldnames:=False
But I would like a step-by-step procedure as to how to do this if possible.
(Screenshots would help please)
Thank you
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
3
2
5 Comments
Active today
The code that you reference is just a single line of code. YOu could "call" that code in the Click event of your button, for example, or during some other "event".
As to step-by-step, that would depend on exactly when you need to do this (i.e what Event you would use), but if you're going to use a Button:
1) Add a button to your form (name it "cmImport")
2) In Properties dialog for the button, select the Event tab
3) Locate the "Click" event, and select "[Event Procedure]" in the dropdown next to it
4) Click the build button to the right of that dropdown
This will throw you into the VBA Editor, and Access will build the Stubs for you. It will look like this:
Sub cmImport_Click()
End Sub
Your code would go between the "Sub" and "End Sub" lines:
Sub cmImport_Click()
DoCmd.TransferText transfertype:=acImportDeli
tablename:="tblMonthlyData
FileName:="D:\Documents\Ex
hasfieldnames:=False
End Sub
You would obviously have to change the Tablename and Filename to match your project.
As to step-by-step, that would depend on exactly when you need to do this (i.e what Event you would use), but if you're going to use a Button:
1) Add a button to your form (name it "cmImport")
2) In Properties dialog for the button, select the Event tab
3) Locate the "Click" event, and select "[Event Procedure]" in the dropdown next to it
4) Click the build button to the right of that dropdown
This will throw you into the VBA Editor, and Access will build the Stubs for you. It will look like this:
Sub cmImport_Click()
End Sub
Your code would go between the "Sub" and "End Sub" lines:
Sub cmImport_Click()
DoCmd.TransferText transfertype:=acImportDeli
tablename:="tblMonthlyData
FileName:="D:\Documents\Ex
hasfieldnames:=False
End Sub
You would obviously have to change the Tablename and Filename to match your project.
Ok thanks, I want to try that out. But I only want to import certain data.
For example. Lets say my Access table has 15 fields, but I only want to import 5 fields from my csv. How would I go about this?
For example. Lets say my Access table has 15 fields, but I only want to import 5 fields from my csv. How would I go about this?
Active today
You can't do so easily, but you can import to a Temporary table, and then use Access methods to move the data from your 5 fields to your "live" Access data. To do that, you'd run code like this AFTER your call to TransferText:
Currentdb.Execute "INSERT INTO YourLiveTable(Col1, Col2, Col3) SELECT Col1, Col2, Col3 FROM YourTemporaryTable"
Obviously you'd need to change the Table and Column names to match your project.
Currentdb.Execute "INSERT INTO YourLiveTable(Col1, Col2, Col3) SELECT Col1, Col2, Col3 FROM YourTemporaryTable"
Obviously you'd need to change the Table and Column names to match your project.
Ok Thanks. Is that run in a Macro as well?
Will the auto-number PK I have in my table populate by itself when I insert this data?
Will the auto-number PK I have in my table populate by itself when I insert this data?
Thanks for your help. So far what you've suggested has worked.
Only, I've noticed the newly imported values have appended "3775" to the front of my auto-number field.
For example, my records will auto-number (incrementing by one each time) and then suddenly they'll change when it gets to the new values.
2065, 2068, 37752069, 37752070, 37752071...
Please help
Only, I've noticed the newly imported values have appended "3775" to the front of my auto-number field.
For example, my records will auto-number (incrementing by one each time) and then suddenly they'll change when it gets to the new values.
2065, 2068, 37752069, 37752070, 37752071...
Please help
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Recently I was talking with Tim Sharp, one of my colleagues from our Technical Account Manager team about MongoDB’s scalability. While doing some quick training with some of the Percona team, Tim brought something to my attention...
This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
- Software-Other
- Databases
- MySQL Server
- MongoDB
- NoSQL Databases
- Percona, *Monitoring tool
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks.
Specify a start-up form through options:
Specify an Autoexec macro:
Us…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have.
In this…
Suggested Courses
Course of the Month7 days, 10 hours left to enroll
729 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.