Inserting multiple lines to multiple rows

[bezza79]

Hi, I'm totally stuck and i'm sure my problem must be really easy.

i want to create an access form with a text box linked to a table. i want users to be able to copy cells from an excel column and paste them into the text box. i then want each row in the text box to be inserted into consecutive row of each table field. how is it done???

Many thanks!

[NeoPa]

I suspect if you show the form in Continuous mode then you will be able to paste in multiple records. If not, then try Datasheet mode.

[bezza79]

Thanks, but i'm not sure this is the answer. If i bring up a continuous form i could paste for instance 8 rows over 8 rows in form view. But this isn't really what i'm after. What I really need is to do is have a text box that i can paste into that will insert the various lines to consecutive rows- just like if i was importing a txt file or somthing similar.

[zmbd]

You may want to take a look that transfersheet method:

http://msdn.microsoft.com/en-us/libr...ice.12%29.aspx

...You can use the TransferSpreads heet method to import or export data between the current Access database or Access project (.adp) and a spreadsheet file...

You should also follow the convestaions linked to this:
One Way To Get Excel into DB


-z