I import a spreadsheet (csv) into my sqli database (keeps a track of all our firewalls) there are 10 excel columns , one for each connected network on the firewall. i would like all these columns to be imported as one entry in the database, so 1 database field would contain all 10 networks. Dont want to do this manually as there are over 500 firewall devices!

could anyone suggest a way to do this?

Recommended Answers

How are you importing at the moment?

Jump to Post

All 4 Replies

How are you importing at the moment?

importing a csv straight into phpmyadmin (Im using WAMP server in my testing)

Ill take a look, thank you

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.19 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.