Importing to row only, in datasheet view (Form)

F

Fredrik

Hello!

I have a form showing all of my orders for a certain date in datatable.
In this form I have a row (Trucknumber) which is empty. I receive an
excelfile from our transporter with trucknumbers. I want to take theese
trucknumbers and copy/paste them into my accesstable, but that does not work.
How do I solve this?
 
F

Fredrik

Hello again.

Ok, then i know. Can anyone please give me suggestions of how to solve this
in an easy and secure way. I will try to explain a little bit closer what i
want to achieve.

I have the main Ordertable in my database:
tblOrder
ORDERNR SUPPLIER LOADINGPLACE ITEM LOADINGDATE TRUCKNR
xxxxxxxxx xxxxxxx xxxxxxxxxx xxxx xx.xx.xx
xxxxxxxxx x xxxxx xxxxxxxxxx xx xx.xx.xx

I export this one to .xls and send to a transporter.
When he returns the .xls file he have added the trucknumbers for every order.

How do i add theese trucknumbers to my records without having to type
everything manually.
I would also like to keep the records and don't just replace them with the
returned data. This because the possibility that the transporter has changed
any data on the orders.

Any suggestions? Thanks!
"scubadiver" skrev:
 
F

Fredrik

Anyone? Please?

"Fredrik" skrev:
Hello again.

Ok, then i know. Can anyone please give me suggestions of how to solve this
in an easy and secure way. I will try to explain a little bit closer what i
want to achieve.

I have the main Ordertable in my database:
tblOrder
ORDERNR SUPPLIER LOADINGPLACE ITEM LOADINGDATE TRUCKNR
xxxxxxxxx xxxxxxx xxxxxxxxxx xxxx xx.xx.xx
xxxxxxxxx x xxxxx xxxxxxxxxx xx xx.xx.xx

I export this one to .xls and send to a transporter.
When he returns the .xls file he have added the trucknumbers for every order.

How do i add theese trucknumbers to my records without having to type
everything manually.
I would also like to keep the records and don't just replace them with the
returned data. This because the possibility that the transporter has changed
any data on the orders.

Any suggestions? Thanks!
"scubadiver" skrev:
Click to expand...
 
P

pietlinden

Hello again.

Ok, then i know. Can anyone please give me suggestions of how to solve this
in an easy and secure way. I will try to explain a little bit closer whati
want to achieve.

I have the main Ordertable in my database:
tblOrder
ORDERNR SUPPLIER LOADINGPLACE ITEM LOADINGDATE TRUCKNR
xxxxxxxxx   xxxxxxx     xxxxxxxxxx       xxxx   xx.xx.xx    
xxxxxxxxx    x xxxxx     xxxxxxxxxx        xx     xx.xx.xx  

I export this one to .xls and send to a transporter.
When he returns the .xls file he have added the trucknumbers for every order.

How do i add theese trucknumbers to my records without having to type
everything manually.
I would also like to keep the records and don't just replace them with the
returned data. This because the possibility that the transporter has changed
any data on the orders.

Any suggestions? Thanks!
"scubadiver" skrev:
Click to expand...

so all you want to do is update the existing data with the truck
number assignments? If so, you could create a link to the Excel file
as a linked table or within your query and run an update query... You
would need a unique ID for each Order to make sure the records are
updated correctly, though. Definitely make a backup of your table
before trying any of this... or you could invalidate your data...
 
Top