Recent content by PHP_Adam

Hello All I have a Excel data which looks like Name | Address Line 1 | Address Line 2 | City | Postcode Then I have Database looking like this: Name | Address How can I Import data from excel to access, and merge all the address data? Im useing Microsoft Office Access 2007 and Excel 2007

Thank You SQL_Hell, I have learned my lesson now, it worked running query like: INSERT INTO 6dclientcontacts (contactid, `Company`, `First Name`, `Last Name`, `Business Phone`, `Mobile Phone`, `Fax Number`, `E-mail Address`, Address, City, `Postal Code`, Notes) VALUES ('1', 'cname', 'fname'...

INSERT INTO 6dclientcontacts (`contactid`, `Company`, `First Name`, `Last Name`, `Business Phone`, `Mobile Phone`, `Fax Number`, `Email Address`, `Address`, `City`, `Postal Code`, `Notes`) VALUES ("1", "cname", "fname", "lname", "onumber", "mnumber", "faxnumer", "emailnumber", "addnumber"...

Thank You SQL Hell. Unless Im missing something I get an error unless I do: INSERT INTO 6dclientcontacts (contactid, Company, First Name, Last Name, Business Phone, Mobile Phone, Fax Number, Email Address, Address, City, Postal Code, Notes) VALUES ("1", "cname", "fname", "lname", "onumber"...

SQL Code INSERT INTO 6dclient (contactid, Company, "First Name", "Last Name", "Business Phone", "Mobile Phone", "Fax Number", "Email Address", Address, City, "Postal Code", Notes) VALUES ("1", "cname", "fname", "lname", "onumber", "mnumber", "faxnumer", "emailnumber", "addnumber", "citynumber"...

Hello, I have two tables: Contacts (id, name, email .......) and ContactsClients (id, contactid, name, email .......) Its quite a simple database where I have a database of my contacts, and a relationship one to many to a database of my contacts clients. I have created a form, to add my...