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
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.
If I want to duplicate just a table, I can easily select "structure only" under paste options. Is there an easy way to do the same thing for an entire database (tables, queries, etc.) all at once?
In short, someone has a database. They're willing to share the database itself, but not necessarily its contents. The database has a user interface, so the people who use the database don't necessarily know much about Access. Therefore, I can ask them to follow a few basic, built-in Access menu options, but can't ask them to do something manually, such as copying the entire file and then manually emptying the tables. This seems like something that should be easy, but I can't find it. Any help?
Thanks,
Rhythm
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 RelatedI am unable to link MySQL database to my local Access Database due to having a Dynamic IP (not the best of providers we chose)...
Is it possible to export a new appended record to a .php file which then sends data to MySQL via a hidden browser?
Sounds very long winded but I cant keep importing data tables directly in MySQL.
Hi, just a quick question. Is there any way of exporting say a query, or a range of quieries to another seperate access database file? ie. create a new database in code?
View 4 Replies View RelatedOK, I have a very large Access database with embedded bitmap photos.
I have realized the error of my ways and would like to list them as linked.
The problem:
How can I get the embedded files out without individually going through, viewing and saving and naming?
Is there a way to save a file do a directory and name it, say the primarykey.bmp or something?
Please help!
I am new to access, and am having trouble getting a correct export of XML out of an access database. I am not sure if it is a schema setup or something else.
I have attached a file that shows the format that is coming from access (Bad Format) and the format I am needing (Correct Format).
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
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.
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
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 RelatedHello 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
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
Hello...
I am trying to export an Access table to a csv file.
I have several fields in the table that are type double and go to 3 decimal places. When I export the data, it truncates it to 2 decimal places.
I changed the table design from "Auto" decimal places to 3. and that didn't help.
When I am in the Table Export wizard, it shows all 3 decimal places, but when I look at the text file, it's only 2.
Anybody ever have this problem?
Thanks in advance!
Greg
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
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
Hi,
Would it be possible for me to build an interface for a customer to use for importing data. So that they customer could choose from a drop down list, or input into a text box where they want to export from, and where they would like the export to be imported?
Hello,
I have a table in Access and would like to export it using code into specific fielfs of a template in Excel.
My table has 3 fields:
SSN
FIRSTNAME
LNAME
I would like to export the recorsed to a template named MyTemplate. This template has a workbook named MyWorkbook.
The only problem is that I need to copy the active recorset (meaning the one which I will select) in a column and not into a row.
Example: I will select a record using a combo and then data will be copied from my Table into the cells B1 (ssn), B2 (FIRSTNAME), B3 (LASTNAME)
Any idea or help? Thanks
i have access 2013 and when i try to export data to excel with "Analyze data in excel" when the file is open i excel i get this error message file error: some data may have been lost". (and a whole row has not been export)
i tried to fix this file with excel open and repair option and i click on "extract data" but then i got this message;
Excel attempted to recover your formulas and values, but some data may have been lost or corrupted.
Excel found errors that may cause some recovered data to be put in the wrong cells.
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 RelatedOn 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.
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?
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
Good morning! I'm using Access to redesign our company's electronic phonebook. Our intranet uses SharePoint technology and our IT people have cranked our security settings up pretty high, so I can't use data access pages or ASP. Therefore, I'm going to use static HTML, producing a single page which the CEO's secretary will upload once a month, allowing our 800+ employees to view the entire phonebook at once. CTRL-F is their friend.
I've managed to design a data access page that looks very much like we want it to, but I don't know how to export it to static HTML. Can such a thing be done, or am I just being wacky? If so, is there a way to automate it so the secretary can just push a button to generate the page?
Thanks,
Andreas
I have an export function below that will export my table "Test" to an Excel Spreadsheet.
However I want it so i can choose where that data in the "Test" table will go in the Excel Spreadsheet i.e. I want to export all the data in to Cell "B2" of the SpreadSheet - at the moment it will export all the data into "A1"
Any help or ideas?
Private Sub Command3_Click()
'Export function
'EXPORTS TABLE IN ACCESS DATABASE TO EXCEL
'REFERENCE TO DAO IS REQUIRED
Dim strExcelFile As String
Dim strWorksheet As String
Dim strDB As String
Dim strTable As String
Dim objDB As Database
'Change Based on your needs, or use
'as parameters to the sub
strExcelFile = "E:CSCLDMSLDMSDatabaseAppLDMS_Spec.xls"
strWorksheet = "WorkSheet1"
strDB = "E:CSCLDMSLDMSDatabaseAppLDMS_IFF_APP.mdb"
strTable = "Test"
Set objDB = OpenDatabase(strDB)
'If excel file already exists, you can delete it here
If Dir(strExcelFile) <> "" Then Kill strExcelFile
objDB.Execute _
"SELECT * INTO [Excel 8.0;DATABASE=" & strExcelFile & _
"].[" & strWorksheet & "] FROM " & "[" & strTable & "]"
objDB.Close
Set objDB = Nothing
End Sub