Exporting To Microsoft Access
I have a PHP website with a mySQL database and a client wants to be able to see the database on his computer using Microsoft Access.
I would like to be able to make a special backdoor section for him, where he enters his username and password and is given a link which will make take a snapshot of the mySQL database and convert it to a Microsoft Access database which he can download to his computer.
Is this possible?
Since he isn't very computer savvy I need a way as user friendly as possible to let him download the database and view on his local computer.
View Complete Forum Thread with Replies
Related Forum Messages:
SQL Error: [Microsoft][ODBC Microsoft Access Driver] Too Few Parameters
I'm trying to execute the following SQL statement and get the following error. SELECT DomainNames.DomainName FROM DomainNames WHERE DomainNames.DomainName Like "*ab*" ORDER BY DomainNames.DomainName SQL error: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1., SQL state 07001 in SQLExecDirect I'm running PHP4, Apache 1.3.12 (Win32) and connecting to an Access database on a Win2K box.
View Replies !
Odbc_exec(): SQL Error: [Microsoft][ODBC Microsoft Access Driver]
i am trying to write to the database through odbc. i get the following error: Warning: odbc_exec(): SQL error: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query., SQL state S1000 in SQLExecDirect in c:inetpubwwwroot514VIP_SurveyProcess.php on line 41 my directory has read/write permissions why am i getting this? here is the code as an example: ... $x = 10; $querySet = "UPDATE Survey SET $rdoOption = $x"; odbc_exec($objConn, $querySet); ...
View Replies !
PHP And Microsoft Access
Is it possible to use php to interface with an ms access database? Our current database (customers, suppliers etc) is in ms access format and we need to run msaccess. I dont feel like converting the whole database over to mysql and we still need the original system, the idea will be that the staff can access the database on the road thru a webpage.
View Replies !
Microsoft Access
I wanted to find out if any of you know the odbc equivalent to mysql_query I'm using a Microsoft Access DB and need to insert values into a table ex. mysql_query("insert into cart(cookieId, MaterialListID, qty) values('" . GetCartId() . "', $MaterialListID, $qty)");
View Replies !
Microsoft Access -> PhpMyAdmin
Alright, so what’s going on is that I have coded an entire website with in mind to have an Access Database. So everything works great... But now I am faced with the problem that I have to have my webpage work with phpMyAdmin, which works completely differently in running my sql statements and everything, ie: ->EOF, select statement, etc... Is there a way for me to have a smooth transition for my code to work with phpMyAdmin instead of Access at the moment, because recoding all of this means an enormous amount of work with not much free time left on my hands. Code:
View Replies !
Problem Exporting Numbers To Text From Access
I am exporting an Access table into text, which is then imported to SQL. My problem is that all exported number fields are given the #.## format, with two decimal places. THis is annoying with integers, but it is killing me with my FLOAT values, for which I need three digits past the decimal. Question: How can I modify Access so that it exports numbers into a text file in the format I desire? I have read documentation about changing this in the Export wizard, but my Wizard gives no option for this, at least that I can find.
View Replies !
Microsoft Access Dropdown List
l am building a new site using PHP which has a lot of pages pulling from an Access Database. I would like to have a dropdown list that pulls exhibitions from the database and then when the user selects one it shows the rest of the details from DB just below the dropdown list, hope that makes sense. Code:
View Replies !
Insert Into Microsoft Access Table Using ODBC
The following lines of code don't return an error but they also do not insert the row into the database: $SQLText="Insert into member (MailingID, MemberID, [File As], EMail, LetterID, AudienceID, DateSent, Sent) Select $MailingCode, $row[0], '".$row[5]."', '".$row[6]."', $LIDToInsert, $AIDToInsert, '".$DateSent."', 1;"; print '<br>'.$SQLText; $rs_upd=odbc_exec($link, $SQLText); if (!$rs_upd) die("Couldn't update database"); I've tested the resulting $SQLText string in Access directly and it works find there so this must be a PHP or ODBC issue.
View Replies !
Inserting A Date Into A Microsoft Access 97 Database
I was wondering if anyone could help me insert a short date into microsoft access 97 using php? i can insert text no problem but i can't seem to be able to insert a date properly. i have been using //$date = "#" . "$sqlmonth" . " 1" . "$cboyear" . "#"; $strSQL = "INSERT INTO tblSupport (tDate) VALUES ($date)"; $result = odbc_exec($connect, $strSQL); Note: i can insert a date if i hard code it like putting in #01
View Replies !
Inserting Records Into A Microsoft Access Database...
I'm still new at using PHP although thanks to these forums I'm learning quite a lot. Currently, I am trying to insert a new record into my access database. I can display records from it but not add new ones. I know that I am to use the 'INSERT' SQL function but how would an Access Database be different from mySQL? So far I've seen only mysql examples and havent been able to find anything on access...
View Replies !
CSV Exporting
I created the csv file, but it only shows the last record in my db. How can I make it show all of the records? Here's the code:
View Replies !
Exporting A Database
developed a php project using mysql as the database.i work on a win-nt machine....how do i export my database to the host server which runs linux???
View Replies !
Exporting To An XML File
I grabbed a web page and had it extract only the links between certain line numbers. Now I want to take that output and export it to an XML file in a format of my choosing. For example: <a href="mysite.com">This is my site</a> Would export to: <link>mysite.com</link> <description> This is my site </description> I will then take that XML file and output it as HTML, however I already have this bit accomplished.
View Replies !
PHP Exporting To Quickbooks
I am working on a web-based payroll application (PHP/MySQL of course) that needs to be able to dump each employee's information in to a Quickbooks formatted file for payroll processing. I have done this several times exporting to a tab/comma deliminated text file (usually MS Excel), but I was wondering if anyone could see any reason why it could not be done the same way (assuming that Quickbooks uses a a tab/comma file structure) for Quickbooks??? If it can be done would I use the same mechanics as I would for Excel (changing the file type meta tag)?
View Replies !
Exporting To CSV Contain Comma In It.
There are some text fields that I am exporting to CSV contain comma in it. And so when I open the csv file, everything is shifted. e.g. "Apple, Banana, Orange", "Excellent", "12345" gives me 5 columns instead of 3 in the csv: Apple Banana Orange Excellent 12345 How can I solve this problem?
View Replies !
Database Exporting
As part of the CMS that I've written, I would like to give users the ability to backup their own databases. Is there any way that this can be done with PHP? What I'd like is for them to click a link and for it to create a txt file and open the "Save as" dialog box so that they can save it off to their hard drive.
View Replies !
Exporting Csv File
I'm having issues getting all the information from 3-4 databases into one csv file.. What easy thing am I missing this time? header("Content-type: application/octet-stream"); header("Content-Disposition: attachment; filename=export.csv"); header("Pragma: no-cache"); header("Expires: 0"); $select = "SELECT * FROM ordersCopy O, orders_products P, orders_total Q WHERE O.orders_id=P.orders_id OR O.orders_id=Q.orders_id AND orders_status=Ɖ'"; $export = mysql_query($select); $count = mysql_num_fields($export); for ($i = 0; $i < $count; $i++) { $header .= mysql_field_name($export, $i)." "; } while($row = mysql_fetch_row($export)) { $line = '' foreach($row as $value) { if ((!isset($value)) OR ($value == "")) { $value = " "; } else { $value = str_replace('"', '""', $value); $value = '"' . $value . '"' . " "; } $line .= $value; } $data .= trim($line)." "; } $data = str_replace(" ", "", $data); if ($data == "") { $data = " (0) Records Found! "; } print "$header $data";
View Replies !
Exporting Mysql
there is a function in phpmyadmin that exports all the data etc from a mysql database to an sql text document, or Excel File. I would like to know if there is an inherent way of doing this without phpmyadmin. - straight through php.
View Replies !
Exporting From MySQL To .csv Using PHP
I'm sort of new to PHP. I am using the following code to retrieve a column from a database and to put all of the results into a .csv file. This allows creates a .csv file, but only lists the first result from the database. It is not returning all of the rows. I know the issue is somewhere in my "foreach" but I'm not sure where. <?php $selectSql = "SELECT artist_name FROM lounge_products"; $selects = $db->getAll($selectSql); foreach($selects as $select) { $content = $select[artist_name].","; } Header("Content-Disposition: attachment; filename=export.csv"); print $content; ?>
View Replies !
Exporting To Excel
I followed the really cool how to at http://www.phpfreaks.com/tutorials/114/0.php but I had to change some things to get it to stop giving me errors. After I did that It seemed to work great but it put everything into one cell in the excel document. Code:
View Replies !
Exporting A Form To PDF
I'm going to be creating an online work order for my company soon and one of the key features I want to build in is the ability to fill out the form, have it create a pdf, and e-mail it. Has anyone done this kind of stuff before?
View Replies !
Help Exporting Database To Pdf
I want to export the products table of my mysql database to .pdf format using php so when you click on a link on the site it opens a pdf file showing all the items in the product table. Ive got as far as getting a .pdf file open and created with just a single line of text in it see code below ....
View Replies !
Exporting To A CSV File
I am working on soe code I found in the forum and trying to get it to work. I am exporting data in to a CSV file for use in excel. The output puts a "," each side of a data field like ,test street,,test town,,test_city, and so on. [php] $export = mysql_query($select); $fields = mysql_num_fields($export); for ($i = 0; $i < $fields; $i++) { $header .= mysql_field_name($export, $i) . " "; } while($row = mysql_fetch_row($export)) { $line = '' foreach($row as $value) { if ((!isset($value)) OR ($value == "")) { $value = " "; } else { $value = str_replace('', '', $value); $value = ',' . $value . ',' . " "; } .......
View Replies !
Exporting To A .CSV File
My .php script is exporting some data to a .csv file. The problem I'm having is displaying data that has multiple lines in it. To keep the linefeeds and CRs from screwing up the .csv file, I am presently replacing LF and CRs with [lf] and [cr]. I can now see these in the csv file when I open it in Excel. I can't find a way to either leave one CR in or LF out (or any combination) so that when I open in Excel the data is on two lines in the same cell. Presently my data in one cell looks like this. This is a[cr][lf] test of[cr][lf] multiple lines. And I want it to end up displaying like this in one cell.
View Replies !
Exporting Data
I need to export data that is in a table to an excel sheet with the field names on top followed by the values of the fields. I know how to extract the data and display with echo statement, however i need the code which would display this information in a excel sheet.
View Replies !
Exporting Sql With Putty
want to export my database with putty. the only problem is I can't find my database file when I search my files. I've searched all my files and still nada. mysqldump -u db_username -p db_name > /path/to/backup.sql
View Replies !
Exporting From Db To Text File
I have the following sql statement that works from phpmyadmin and from the MySQL command line, but not php. The resultant $sql variable is the following: $sql=select logrecno, county, sumlev into outfile "/tmp/census.txt" fields terminated by ',' lines terminated by "" from sf1_msageo where sf1_msageo.county=97 and sf1_msageo.sumlev=140 $result=mysql_query($sql); The query executes, returns no messages, and does not create a file. Any idea as to what I'm doing wrong?
View Replies !
File Exporting To Excel
This code exports data from my DB into an Excel file by using " " as the delimiter. It runs through the script over and over until it's done creating an Excel file with columns of data, but is there a way that I can add a value to the beginning of the script - thereby naming the columns? Code:
View Replies !
Exporting Question (sort Of)
I've been using this site as a reference while building my first-ever php/mysql site. I know database concepts fairly well, but php is new to me so I'm going in blind. I'm making a contact manager and the client wants to be able to use checkboxes to select email addresses on MULTIPLE pages within the system, then have them output somewhere locally as a CSV list. Code:
View Replies !
Exporting To Excel 2003
I had a PHP script that used to successfully output to Excel 2000. I used the header statements header ('Content-type: application/vnd.ms-excel'); header ('Content-disposition: inline; filename=output.htm'); Last year I upgraded to Excel 2003, and now the output is just a table that shows up in the browser.
View Replies !
Exporting Data To Excel
1) can i have combo boxes to select what i would like to export, then write them to an excel file? how can this be done? i need some help & guidance for it. i need to understand how do i draw the data if i have multiple combo boxes that i would need to select before exporting the data. simply saying that i have a form with a few multiple select boxes to select what i want to export to excel. how can it be done? 2) an alternative that i'm thinking is that, to have an export link on the page which i'm viewing the data. so that it would only export the relevant data which i'd be looking at. i might need a few export functions for different modules of the system. Eg. export participants for certain event; export members of certain clients; export event details from a certain date range;etc... i must be able to select which ever data is most relevant for the export.
View Replies !
Exporting Result Set To MS Excel
I need to display a list of dealers on screen that are grouped by state and alphabetized. All states need to be shown. In addition, each dealer needs to have a checkbox next to dealer name. For Example, I need to show the following on screen: Column1--> state1 Result 1-->(checkbox) Dealer1 in state1 (checkbox) Dealer2 in state1 (checkbox)DealerX in state1 Column2--> state2 Result 2--> (checkbox)Dealer1 in state2 (checkbox)Dealer2 in state2 (checkbox)DealerX in state2 Column2--> stateX Result 2--> (checkbox)Dealer1 in stateX (checkbox)Dealer2 in stateX (checkbox)DealerX in stateX this is my sql query to retrieve the data ==> "select dealer_id, name FROM `dealer` order by state,name" QUESTIONS: 1. I would like to loop through the result set to see whether or not the "state" field changes. When it does, I want to start a new column. Then after x columns have been created on the page, i want to move 2 rows down to begin with the next column. Does anyone have a code example for this or anything similar? PART 2 Once dealers are shown by state with a checkbox next to the dealer name, the user should be able to select X number of dealers and then click submit. This would execute the following query ==> "select name, state,zipcode from dealers where dealer_id(which will be passed in the checkbox) in (1,2,.,n)" The results need to open within microsoft excel with the following format: state1 (bold) name1 zip2 (located in column B in Excel) state2 (bold) name2 zip2 (located in column B in Excel) stateX (bold) nameX zipX (located in column B in Excel) QUESTION 1. How can i have microsoft excel automatically open with the result set within the worksheet? 2. How can I format the sheet to display my desired format above?
View Replies !
Exporting To A Specific Folder
Below outputs data to any folder ($PATHFILE) I specify: PHP Code: $query = "SELECT * INTO OUTFILE '$PATHFILE' FROM customers"; $result = mysql_query($query); However, I want to export this code's output to any server folder I specify too. But it seems to be only for downloading to my Desktop: PHP Code: $sql = mysql_query("SELECT * FROM customers"); // select shippable products only! while($row = mysql_fetch_array($sql)) { $contents.=$row['firstName']." "; $contents.=$row['lastName']." "; $contents.=$row['address1'] ." "; $contents.=$row['address2'] ." "; $contents.=$row['city']." "; $contents.=$row['state']." "; $contents.=$row['zip']." "; ...........................
View Replies !
Exporting ASCII Codes
I am having trouble exporting records from one MySQL db to a .sql file, and then importing into my local MySQL here on my machine. It is doing something funky w/ the ASCII code characters. For example, I'm trying to export a record that contains the ™ mark.Code: INSERT INTO `categories` (`cat_id`, `cat_title`) VALUES (1, 'UltraMAX™ Standard and Plus Series'); But when I do it from the live server, that record comes through like this: Code: INSERT INTO `categories` (`cat_id`, `cat_title`) VALUES (1, 'UltraMAXâ„¢ Standard and Plus Series');
View Replies !
Exporting Data From MySQL
Once they select the job and click on the submit button I want it to display every item in the jobs respected row. I know this can be done but, not sure what I am missing; <?php $sql1 = mysql_connect ("localhost", "username", "password") or die ('I cannot connect to the database because: ' . mysql_error()); $dbh = mysql_select_db ("database"); $job = $_POST['job']; $result = mysql_query('SELECT FROM jobs WHERE Job=$job'); $results = mysql_fetch_array ($result); print $results; ?>
View Replies !
Exporting MySQL Database To File Using PHP
I want to export my database to a file that is hosted on the same server. I got this script from somewhere, but it doesnt work. Most likely because I cannot access mysql command thru the shell_exec() command, however, I am able to use the wget command thru the shell... Here's the code I was trying to use:
View Replies !
Exporting Search Results To A CSV File
I am about to start programming up a database, where the client requies the data exported to a CSV file for use in mail merge documents etc. What I would like to know is, if they run a query on the database, and only export five of the 10 fields in the table to the list, how would I go about reatining the field names on the first line of the CSV file?
View Replies !
Exporting Mysql Data To CSV In Php Code!!
how can i export the results of a query to a csv file with the columns name in the filed name of the csv???suppose USERID is the 1st column the USERID should be named in A in CSV while its data is under of it??is it possible?
View Replies !
Exporting Information From Entourage To A Website.
I have this new website for a client, it has a calender which shows events from a mysql database but they don't want to have to update the information to it manually. What they are using is a program called Microsoft Entourage. What are the possible ways for me to be able to get that information every 1 hour and get it into a database?
View Replies !
BBCode Parsers And Exporting Text From A DB
I'm currently working on a simple (at least I had hoped) script to pull posts from a single "news" forum from phpbb and importing it on the front page of my site. It works great except for the BBCode issues. It doesn't keep line breaks (biggest concern) as well as text colors, urls, etc (which was expected). Talking with a friend, he tells me that I'm going to have to insert some BBCode parser to make things work right. I have 3 questions regarding this: 1) is that my only answer? 2) should I try to use the phpbb BBCode parser that the forum uses? 3) should I install a custom BBCode parser instead? I did not want to use a portal because they were just over bloated for what I needed and that was simply the posts from the forum itself w/o all the extras like who's online, last post made on the forums, etc. Would it just be easier to try to strip down something like EZportal to just the info I need instead of trying to use this custom script?
View Replies !
MYSQL Exporting Encrypted Columns
I'm having an issue with an application someone else built and they have seemed to encrypt a column, this comes up even when I export the table to a csv file for excel, can anyone show me how to remove this.
View Replies !
|
TRACKER
