[SOLVED] help with simple insert

[knowram]

I am new to mssql and am trying to move my info from a mysql database to a mssql database. I have just about everything figured out but the INSERT INTO part. what do you used to separate rows. Here is what I have so far

 

INSERT INTO Associa_Networkinfo (Member_Company, Office, Address, Domain, Network_Connection, Device_Name, Serial_Number, Device_Type, Interface, IP_Address, Mask, IAF, Description) VALUES 
('Community Archives', 'Community Archives - Tucson, AZ', '7580 N. La Cholla Blvd|Tucson|AZ|85741', 'CA', 'Point to Point', 'CA-2821-B-7580', '', 'Router', 'Serial0/0/0|GigabitEthernet0/0.2|', '192.168.255.2|192.168.58.1|', '/30|/24|', '||', 'Router - P2P Link|Router - Data VLAN|'),
('Community Management Corporation', 'CMC - Fairfax, VA (HQ)', '12701 Fair Lakes Circle Suite 400|Fairfax|VA|22033', 'CMC', 'NVPN', 'cmc_main', '', 'Router', 'GigabitEthernet0/0|Serial0/1/0|Serial0/0/0:0.2|Serial0/0/0:0.3|', '172.16.111.254|66.10.156.142|192.168.254.9|192.168.254.1|', '/24|/30|/30|/30|', '|1138940|||', 'Router - Data VLAN|Router - NVPN Link|Router - P2P Link|Router - P2P Link|');

 

And I am getting an error on , between the rows.

 

Thanks for the help

[jamina1]

Make sure none of your values have ' s in them else it will throw off the query.

 

Also, you'll have to use seperate INSERT INTO statements for each row, as far as I know.

[sushant_d84]

Hey ...........

 

There are number off tools available for this type conversion

 

just search by "Mysql to MS-Acess conversion" u will get lots of stuff

 

 

Regards

Sushant