G
Guest
Here is the deal. I have about 10 excel spreadsheets that show different
charts ect. and most have repeating data. I am trying to create a database
so the information doesn't have to be entered 3 different times. The data in
excel is imported from a tab delimited file sorted subtotaled and creates a
small table of information that should be in the database. Is it possible to
make a form that has a drop down box for the week number (already linked to
other tables) and paste the data from the spreadsheet and append that
information to the end of the table with the week number in front. Here is
my example
Database table
ID Week Orders Items Root Cause
Details
(automatic) 1-07 3 3 insufficiant inventory
Count Misc
Excel Table All Week 2-07
Root Cause Items Orders
Insufficient Inventory Count 10 10
Miscellaneous Count 8 7
Hold Count 1 1
Shipping problem Count 1 1
charts ect. and most have repeating data. I am trying to create a database
so the information doesn't have to be entered 3 different times. The data in
excel is imported from a tab delimited file sorted subtotaled and creates a
small table of information that should be in the database. Is it possible to
make a form that has a drop down box for the week number (already linked to
other tables) and paste the data from the spreadsheet and append that
information to the end of the table with the week number in front. Here is
my example
Database table
ID Week Orders Items Root Cause
Details
(automatic) 1-07 3 3 insufficiant inventory
Count Misc
Excel Table All Week 2-07
Root Cause Items Orders
Insufficient Inventory Count 10 10
Miscellaneous Count 8 7
Hold Count 1 1
Shipping problem Count 1 1