Transfering MYSQL Data To An ACCESS Database- HELP ME!

Oct 31, 2005

Could someone please help me?

At work we have a website with a mysql database attached to it. It keeps data such as customer name address postcode contact id etc.

Currently our main database is made in access.

I need to transfer data from the website database (which is in mysql) to our access database. And would like this to happen regulary. We have been quoted £1800 for someone to do this!

As this is a new job i would like to be able to do this myself, is it hard to do?

Could someone provide me with some information of how to do this? or where to start.

Much appriciated.

View Replies


ADVERTISEMENT

Export Data From An Access Database To MYSQL

Jul 17, 2007

Hi There,

Whereabouts would I change the date format from the access database from yyyymmdd ?

I am trying to convert this table from access into mysql, and when I ouput to a csv file the date is in access.

Many Thanks

Chris

View 1 Replies View Related

Using MySQL BackEnd With Access FrontEnd For Multi-User Database

Mar 31, 2015

If I want to distribute a front end to connect with a MySQL back end ... do I need to set up the system DSN on each workstation that will be using the front end?

View 4 Replies View Related

Transfering Data, Can Any 1 Help

Feb 9, 2005

I am currently studying for my A levels and need some help with microsoft access. What I want to do is transfer information from one table in my database to another. When it transfers however, I want it to alter under a certain validation. This is what i want to do;

Admission numberArt
011649
011650 F
011651 B
011652 C
011653

This is an example of the information. The letters regard to a GCSE result. I want the grade to be transfered to a table called "point score". Each grade has a value, A* = 8 points, A = 7 points, B = 6 points and so on. When the data is transfered to the point score, I want it to just state the point score and not the grade. Can anyone help?

Cheers

View 1 Replies View Related

Transfering Data

Apr 29, 2005

Hello everyone,

I am still trying to solve the following problem:
I am trying to transfer data from one table to the other in a different folder using the follwing command:

Private Sub Commandtransfer_Click()

DoCmd.TransferDatabase acImport, "Microsoft Access", "D:DBSsewertvinsp.mdb", acTable, "tblSanTV", "tblSanTV"

End Sub

By using the above command I could be able to transfer "tblSanTV" table from D:DBSsewertvinsp.mdb to another table in a different folder but it transfer the table and data together. But that is not what I want to do. All I want to do is to transfer the new data from one table to existing data in another table. These tables have the same names but different field names.

I tried the following command to solve my problem, but I end up with more problems than solution:

PPrivate Sub Commandtransfer_Click()

DoCmd.TransferDatabase acImport, "Microsoft Access", "D:DBSsewertvinsp.mdb", acTable, "tblSanTV", True, "INSP#; MAINLINE ID#;US MH ID#", "tblSanTV", True, "INSPNO;MAINLINE; SAN_MH_FROM"

End Sub

In the above command, I was trying to import data from "D:DBSsewertvinsp.mdb", tblSanTV" table to the general database. But I want data in the field "INSPNO;MAINLINE; SAN_MH_FROM" in "tblSanTV" goes to the corresponding fields in general dabase "tblSanTV" table, fiel "INSP#, MAINLINE ID#,US MH ID#" consecutively.

I want somebody help me out with this issue. Please help me. Thanks.

Girma

View 1 Replies View Related

Transfering Data

May 27, 2005

Hello everyone,

I have still an issue with tranfsfering data from two tabels to another two tables which have parental relationship. A while a go on this forum someone have suggested to me to use the append query but that only works to append to one table, which is not my case.

If I don't transfer these two tables together or at the same time, they will loose their relationship because of their relationship which is auto number.

I have tried to modify the append query SQL and didn't work for me. Please someone help me solve this problem or tell me other alternative way of doing this. Somone look at the following modified append query and see where I made a mistake or cannot do it this way:

INSERT INTO tblSanTV ( INSPNO, MAINLINE, [US MH ID#], [DS MH ID#], [ADDRESS#], [STREET NAME], [CROSSING STREET], [FL TYPE], [P SIZE], [MT TYPE], [MH DEPTH], [P LENGTH], [SITE CONDITION], REVERSE, HEADING, [INSP DATE], [TAPE#], [TAPE START], [TAPE STOP], [INSPECTOR NAME], [PROJECT NAME], [PROJECT NUMBER], [REP TYPE], [REP PRIORITY])
INSERT INTO tblSanTVmk (DISTFROM, DISTTO, [COUNTER], [OBS TYPE], CATEGORY, DIRECTION, [SC PERMIT#], COMMENTS, [PHOTO CLIP] )
SELECT SANTV2.[INSP#], SANTV2.[MAINLINE ID#], SANTV2.[US MH ID#], SANTV2.[DS MH ID#], SANTV2.[ADDRESS#], SANTV2.[STREET NAME], SANTV2.[CROSS STREET], SANTV2.[FL TYPE], SANTV2.[P SIZE], SANTV2.[MT TYPE], SANTV2.[MH DEPTH], SANTV2.[P LENGTH], SANTV2.[SITE CONDITION], SANTV2.REVERSE, SANTV2.HEADING, SANTV2.[INSP DATE], SANTV2.[TAPE#], SANTV2.[TAPE START], SANTV2.[TAPE STOP], SANTV2.INSPECTOR, SANTV2.[PROJECT NAME], SANTV2.[PROJECT#], SANTV2.[REP TYPE], SANTV2.[REP PRIORITY], tblSanTVmk2.DISTFROM, tblSanTVmk2.DISTTO, tblSanTVmk2.COUNTER, tblSanTVmk2.[OBS TYPE], tblSanTVmk2.CATEGORY, tblSanTVmk2.DIRECTION, tblSanTVmk2.[SC PERMIT#], tblSanTVmk2.COMMENTS, tblSanTVmk2.[PHOTO CLIP]
FROM SANTV2 INNER JOIN tblSanTVmk2 ON SANTV2.[INSP#] = tblSanTVmk2.[INSP#]
WITH OWNERACCESS OPTION;

I tried to modify the append query to the above format but didn't work. I even tried "inner join" to put the above table together but I could be able to make it work. Anybody knows how to solve this, please help. Thanks.

Girma

View 12 Replies View Related

Transfering Data Between Databases

Jun 26, 2007

i have 3 databases containing data in the same format.

basically i work in a school, and have a database for 3 different classes.

each database has a table containing the childrens details(table a), and a linked table (through primary key in table a) to targets and points scote for each week.

--table a--
child number
name
carer
address
etc

--table b--
index
child number (linked)(displayed as childs name in table, but stored as a number)
week starting
target 1
target 2
target 3
points 1
points 2
points 3
etc


now this database has been working really well. but if ever a child has to be moved class then i need to be called to transfer the records manually (because nobody else can do it) and i have to get the records manually and copy and paste them between databases. This works fine and i've had no problems. And the auto number in table a is changed from the original. but this seems to automatically corrolate to table b when i paste that over. so everything is working fine.
but....
first of all, it creates lots of work for me when kids move classes, and also if i'm not there nobody else can do it.
so....
i've tried using an append query to transfer the data. I tried using 2 append queries (1 for each table).
but....
it works fine for table a, but i'm having trouble with table b.
the append query for table b pastes all the records into the equivalent table on the other database through searching all records related to childs name on table a, therefore retuning all records in table b for that child.
the problem.......
when this data is transfered it transfers table a data fine. but table b is fine except for the fact that it doesn't transfer the childs name data (number), which i can kinda understand, but from what i can understand, my queries are doing the same thing as if i was to cut and paste manually and it works fine when i do that.

ok so its all very confusing, and i hope ive explained adequetly.
oh and btw, i can't put it all in 1 database, because each class may need to access the database at the same time.

thanks


adam

View 4 Replies View Related

Transfering Data Dynamically

Oct 1, 2005

Hi,

I have a subform called "Earthwork". I also have a query called earthwork200 and I need to dynamically transfer data from the earthwork to the query based on a certain column.

for example, the earthwork column i am using to transfer data to the query is "Desc" (the name of the column). How do i get data to dynamically goto the query as I click on a new item under the "desc" column?

Kindly HELP!!

View 1 Replies View Related

Help Transfering Data From On Form To Another

Jan 24, 2006

I have a tbl called table1 which has 3 fields. i have a form called form1 which list field1 for all records in table1. when i double click on field1 i want to open form2, retrieve the data from table1 using field1 as input and display the results onto form2. can this be done just using Access or do i need visual basic? i am new at Access and have not ever used visual basic. i do know java. can you tell me how to do this or suggest a book which could explain it. the access book i have does not go into this type of detail.


thanks
brian

View 3 Replies View Related

Transfering A Spreadsheet To Access Table

Oct 4, 2007

hello

i would like some advice so i do this correctly.

I have a access database with a customer table. And a excel spreadsheet wih customer details. I wish to transfer all the excel spreadsheet customers into the database - customer table.

The format of the customer table in the database is...
Customer ID
Customer Surname
Customer Forename/s
Position
Company Name
Address Line 1
Address Line 2
Address Line 3
Town/City
County
Postcode
Telephone
Mobile
Fax
Email Address
Type Of Business
No Of Employees
Capture Method
Preferred Contact Method
Newsletter/Fact Sheet
Update Auto Recieval
Additional Notes
Passed On to Partner Organisations
Date Input
Web Address
Chamber Member
Description
Month & Yr Est
Website ID
Complained?


The format of the excel spreadsheet is....
Contact(consists of forname and surname)
Role
Email
Tel.
CompanyAddress(has to lines add 1 and add 2)
City
Postcode


I need to make fields match from the spreadsheet to the field table on the database?

can someone please provide me with steps as to how to transfer the spreadsheet into the database correctly?

thanks a lot

View 4 Replies View Related

Importing Data From MySql

Apr 5, 2006

Hi,

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

View 6 Replies View Related

MySQL Amd Access

Feb 7, 2006

I am building my frist database with MySQL as a backend to Access. I am using the ODBC driver and it looks very interesting. I have a question already though. I know that I can use the InnoDB engine and create relationships within MYSQL to enfro referential integirty, but should I? Or should I create the relationships in Access and let Access do the enforcing? Will my Access application report MySQL errors?

Thanks for the time.

View 2 Replies View Related

Mysql Access

Mar 13, 2006

I have a mysql database on my website (remote db). And i want to link to this database in acess(local bd) so that i can manipulate data.

How is it possible

View 1 Replies View Related

Access V.S. MySQL

Apr 22, 2006

Hey, Just wanted to throw the question out there, I already asked another member on their opinion on this but havent heard anything back yet, so im going to also throw the quesation out here as well and see what i get. Im new to databases and started out trying to learn Access with the intention that what i learned in Access i could use to learn MySQL, I figured access was a easier starting point to get my feet wet. I eventaully want to apply my databases to the web and im not sure but just wanted to find out. Does access have capabilities to manage a site where customers create an account on the site and log in and everything?? I was thinking access cant really do it and if it could it might be hard, so thats why i was looking into MySQL. I guess what im really asking is whats the difference between Access and MySQL, and what advantages and disadvantages do they have?? Everybodys opinion is welcome, it all helps me out. Thanks! ~[MikE]~

View 5 Replies View Related

ACCESS And MySQL

May 31, 2006

Hello everybody,

Who can help me.
I want to access a MySQL database with ms access.
I cant seem to get it.

Please help me.

Thanks in advance,
John

View 2 Replies View Related

Access And MYSQL

Aug 25, 2003

Hello to all
this is my first post

i am havinga problem with my access database
so i started to converted it to MYSQL

but after converting it and running asp script it gives the following error

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E09)
[TCX][MyODBC]You have an error in your SQL syntax near 'SELECT tblTopic.Topic_ID FROM tblTopic WHERE tblTopic.Forum_ID = 4 ' at line 1
/mycplus/forum/Default.asp, line 335


and the orignal sql statement in ASP Forums is

strSQL = "SELECT " & strDbTable & "Author.Username, " & strDbTable & "Author.Author_ID, " & strDbTable & "Thread.Topic_ID, " & strDbTable & "Thread.Thread_ID, " & strDbTable & "Thread.Message_date "
strSQL = strSQL & "FROM " & strDbTable & "Author, " & strDbTable & "Thread "
strSQL = strSQL & "WHERE " & strDbTable & "Author.Author_ID = " & strDbTable & "Thread.Author_ID AND " & strDbTable & "Thread.Topic_ID IN "
strSQL = strSQL & " (SELECT " & strDbTable & "Topic.Topic_ID "
strSQL = strSQL & " FROM " & strDbTable & "Topic "
strSQL = strSQL & " WHERE " & strDbTable & "Topic.Forum_ID = " & intForumID & " "
'strSQL = strSQL & " ORDER BY " & strDbTable & "Topic.Last_entry_date DESC) "
'strSQL = strSQL & "ORDER BY " & strDbTable & "Thread.Message_date DESC;"

it was fully working in ASP + Access forums

Thanks
Plz help me


View 2 Replies View Related

Using Access As A Front End To MySQL

Sep 16, 2005

I have Microsoft Access on my desktop connecting to a MySQL database at my host, using an ODBC driver. I can read the data just fine. But when I try to add another record, it won't seem to do it.

Is it possible to update a MySQL database from MS Access on my desktop?

I have just one table. Very simple. Is it to do with primary key number generation or something?

Thanks,

Jon

View 1 Replies View Related

Connecting To MySql From Access

Feb 26, 2006

Hi all,

hope someone can help me with this.

Before we moved webhosting company we could have external access to our MySql database which was great as our MS Access system would periodically pull data from our MySql site (namely customer enquiries which were entered via a form on our website) and dump them in our MS Access live quotes table all automatically.

With our current host (which seems to be the norm from my web-searches) they only allow local access to the MySql system.

My question is, how can I oversome this hurdle without having to move hosting company. I really don't want to move again as it's a real pain.

All suggestions welcome.

ahrint

View 2 Replies View Related

Looking For Experienced Access/MySQL Developer

Nov 10, 2005

I have an existing MS Access/MySQL app that I need an experience developer to develop further. The existing application is fairly complex, so experienced developers only.

View 2 Replies View Related

MS Access Distribution With MySQL Backend.

Feb 2, 2007

On my development machine everything works great, but I know that I'm going to run into problems with distribution.

I don't think there is a way, but I'll ask. Is there any way to get around not having to install the ODBC MySQL drivers on each computer? One of the reasons I'm migrating to MySQL for a backend is the fact that I'll be going from 10 users to 150 users, each of which has a "locked down" PC, which would mean logging into each with Admin rights to install the driver. Not an impossible task, but a pain.

Is is possible to have a "shared" source for the driver? I have only a rudimentary understanding of that process.

Thanks in advance for any help that someone can provide, or some answers pointing me in the right direction.

View 1 Replies View Related

Linking Access To MySQL Issues

Jun 8, 2007

I have converted my MS Access database tables to MySQL Server tables. I am trying to use the MS Access front end to cooperate with the MySQL Backend database. I have created a system DSN, without problems.

My issue is when I Open MS Access --> Open File --> Files of Type: ODBC Databases, nothing happens. It does not give me the option to connect to the MySQL database I just created. I also tried to import data by linking tables (again, choosing the ODBC databases option), and it does the same thing. Does anyone know what I may be doing wrong?

View 4 Replies View Related

MYSQL -> Access (update Query)

Oct 17, 2007

I'm new to access and I'm trying to learn the functionality by creating a relational DB for US zip codes from an excel document. I've imported everything and I have the tables setup. Is there a way to run a MYSQL query like this:

UPDATE tbllocation, tblzipcode SET tbllocation.ZipID = tblzipcode.ZipID WHERE tbllocation.ZipID = tblzipcode.ZipCode;

in access 2007?

Thanks

View 2 Replies View Related

Front End = Access; Back End = MySql Problem

Mar 8, 2008

Hello

I“m working in an application using Access as FE and MySql as BE.

When I add some registers to this linked table, OK.

Problem: When I try to add a lot of registers (700.000!) it does“nt work and the msg is that the computer does“nt have memory resources to do the job.

If I try the same with Access tables it works fine.

MySql configuration, perhaps?

Thanks a lot

Renato

View 9 Replies View Related

Connect Access Front End To Mysql Back End

Dec 14, 2006

I have seen it done in the past but at the time my limited knowledge did not retain how to do it, it is connected through the odbc, im am running server 2000

what code do i use to connect and how do i set up the odbc

any help would be appreciated

Jabez

View 1 Replies View Related

Using Access Form Fields In Pass-through Queries To MYSQL

May 9, 2005

I don't know if this is thebest place for this, but here goes....

I have an Access FE using MYSQL 4.1 BE. I have several forms and PassThrough queries (using MYSQL syntax not supported or available in Access).

How can I use form field values to use as criteria for these queries?

FOr example, in a pure Access database. I may have a form 'Employees' with a text box 'EmployeeName'. THen have a query....

SELECT * FROM tblEMployees WHERE EmployeeName = [Forms]![Employees]![EmployeeName]

If I were to add this variable to my pass-through queries, it errors. How can I do the same thing, passing my form fileds to an Access Query? I am trying to do this right in the SQL view of the queries, not in VBA or Macros or anything.

Thanks,
Scott

View 2 Replies View Related

Transfering Old Records

Nov 11, 2005

Hey All,

This may have been covered already, and if it was I appologize. Searched for it but couldnt find it.

Any how, I have a large table of records (problem is its growing). It lists customers and dates. My table has way to many records, so i need to condense it a little bit. What i need to do is transfer contracts that have been fulfilled (by date) transfer to another table that contains records of contracts that have been fulfilled. I want to do this by a push of a button, automatically transferring any records that the date has passed to the pastcontract table.

Any ideas? Im not quite sure how to proceed.


Mateo

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved