By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,790 Members | 1,407 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,790 IT Pros & Developers. It's quick & easy.

Inserting multiple lines to multiple rows

P: 2
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!
Jun 29 '12 #1
Share this Question
Share on Google+
3 Replies


NeoPa
Expert Mod 15k+
P: 31,418
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.
Jun 30 '12 #2

P: 2
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.
Jul 3 '12 #3

zmbd
Expert Mod 5K+
P: 5,397
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 TransferSpreadsheet 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
Jul 3 '12 #4

Post your reply

Sign in to post your reply or Sign up for a free account.