Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Importing / Linking / December 2007

Tip: Looking for answers? Try searching our database.

how to import data from Word textbox into Access

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Krešo - 27 Dec 2007 16:11 GMT
hi, i have a problem;
i have several thousands of ms word documents and i want to import
that data in access.
problem is that the data is in textboxes (all files have the same
template - 7 textboxes in same places of course) ... how to transfer
data in textboxes in access?
thanks in advance
Jeff Boyce - 28 Dec 2007 15:31 GMT
Perhaps if you provided an example of the data you have in Word...?

Regards

Jeff Boyce
Microsoft Office/Access MVP

> hi, i have a problem;
> i have several thousands of ms word documents and i want to import
[quoted text clipped - 3 lines]
> data in textboxes in access?
> thanks in advance
Krešo - 28 Dec 2007 17:04 GMT
> Perhaps if you provided an example of the data you have in Word...?
>
[quoted text clipped - 16 lines]
>
> - Prikaži citirani tekst -

yes, here's example... i have 30k of those :)
http://www.filecrunch.com/file/~py1e8m
thanks in advance
Jeff Boyce - 28 Dec 2007 17:36 GMT
You'll please understand my reluctance to visit a website I'm referred to
via these newsgroups...?

Please post the data as an example, rather than the document.

Regards

Jeff Boyce
Microsoft Office/Access MVP

On 28 pro, 16:31, "Jeff Boyce" <nonse...@nonsense.com> wrote:
> Perhaps if you provided an example of the data you have in Word...?
>
[quoted text clipped - 16 lines]
>
> - Prikaži citirani tekst -

yes, here's example... i have 30k of those :)
http://www.filecrunch.com/file/~py1e8m
thanks in advance
Krešo - 28 Dec 2007 17:44 GMT
> You'll please understand my reluctance to visit a website I'm referred to
> via these newsgroups...?
[quoted text clipped - 31 lines]
> yes, here's example... i have 30k of those :)http://www.filecrunch.com/file/~py1e8m
> thanks in advance

oh :)
data inside these textboxes in word document is plain text,. :)
Krešo - 28 Dec 2007 17:51 GMT
it looks like this:

reg.broj: [textbox]

prezime i ime: [textbox]      dob: [textbox]
zanimanje: [textbox]           prebivalište: [textbox]

anamneza:
[textbox]

inside textboxes is plain text
Jeff Boyce - 28 Dec 2007 18:33 GMT
I'm not familiar with "textboxes" in Word.  Are you using tables in Word?

Can you export from Word to Excel?  If so, you could then import the Excel
data into Access.

Regards

Jeff Boyce
Microsoft Office/Access MVP

it looks like this:

reg.broj: [textbox]

prezime i ime: [textbox]      dob: [textbox]
zanimanje: [textbox]           prebivalište: [textbox]

anamneza:
[textbox]

inside textboxes is plain text
Pete D. - 30 Dec 2007 14:41 GMT
Here is one way to do it.
Import Data Directly from Word Forms to Access Tables:
http://msdn2.microsoft.com/en-us/library/aa155434(office.10).aspx

> I'm not familiar with "textboxes" in Word.  Are you using tables in Word?
>
[quoted text clipped - 17 lines]
>
> inside textboxes is plain text
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.