J
Jennifer Sanders
We're taking the old database from our e-commerce site and
trying to fit it into a new database wita a different
architecture.
Since a lot of fields have different names from the
previous DB, I've opted to just copy and paste all the
data. The records will stay in the same order for the two
main tables: the products table and the user table.
When I go to paste all the product titles, however, I get
an error that says that products.product_ID (the primary
key for the products table) cannot be a null value. Then
it tells me it's creating an error file for the rest of
the clipboard, and doesn't paste anything.
How can I override the product_id column's need for a
value in each field so that it will paste an entire column
(2500 records)?
Is there a better way for a novice to import a large
amount of data into a new data structure?
trying to fit it into a new database wita a different
architecture.
Since a lot of fields have different names from the
previous DB, I've opted to just copy and paste all the
data. The records will stay in the same order for the two
main tables: the products table and the user table.
When I go to paste all the product titles, however, I get
an error that says that products.product_ID (the primary
key for the products table) cannot be a null value. Then
it tells me it's creating an error file for the rest of
the clipboard, and doesn't paste anything.
How can I override the product_id column's need for a
value in each field so that it will paste an entire column
(2500 records)?
Is there a better way for a novice to import a large
amount of data into a new data structure?