Store Invetory to SQL

Databases
1

So at the retail store I work at the manager uses Quickbooks to hold the store inventory. She had an idea to connect the store website with a database that looks back at the Quickbooks inventory.

That way, if we sell something on quickbooks and get out of inventory, it will be updated on the database, thus updating it on the website.

I exported the inventory list to a .xlsx file to view it in Excel. So from this point, can I import this into a fresh database?

And is the above listed in the first two paragraphs doable?

Thanks in advanced,

-Chris

2

very doable

which database did you want to use?

3

r937,

I wanted to use a mySQL database (if that’s what your question meant)

And forgive me for being a little slow, I never really dabbled in the database world.

-Chris

4

if your data consists of rows and columns, and you can create a csv (or tab-delimited, or whatever), then with mysql, you’re good to go

check out the LOAD DATA INFILE command

all you need to do is declare the table first

5

r9327,

I imported the file via phpmyadmin (again im a noob so the graphical interface helps) into one table with the name TABLE1.

It contains all 3,000+ records (which is correct so it seems like it took everything in)

The only problem is when I browse TABLE1, only 1 column exists (COL 1) and it looks like everything is crammed on one line.

In reality 10 columns should exist for each item in the inventory. So from the looks of it, it didn’t take the column headers out of my document, just the rows.

Thanks in advanced,
Chris

6

sorry, i don’t use phpmyadmin, so i can’t tell you how to fix that

but underneath the covers i bet it’s generating the LOAD DATA INFILE command, so see if there are options where you can specify your delimiters, because that’s why you have only one column, the delimiters didn’t get recognized

7

Hi cluongo

if you want to use a graphic tool and you have been granted access (as a user) to connect to the database (other than using PHPMyAdmin) you may consider using MySQL administrator and MySQL query browser.

Opening Query Browser will allow you to issue and run SQL commands against the selected database, but doesn’t make you do all work through writing SQL; some of the SQL it does for you behind the scenes.

If your going to do much work with MySQL it is a good idea to also learn to use the command line as it is likely you won’t always have your GUI MySQL tools available.

Also if your interested in learning more about SQL, don’t be afraid to purchase Rudy’s book (See his Signature) as it is excellent and simple to understand.

Hope this helps.
Steve