Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 18th, 2006, 03:17 PM
Registered User
 
Join Date: Mar 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default import from word

I have created a word form to be used by many people and I need to import the completed table directly into access 2002. The trouble I have is when I create a text delimited file from this I cannot then get the column tables created in Access becuase the word format is in the following format:

name: namedata
address: addressdata
postcode: postcodedata etc.

The problem is it uses name and namedata as the column headings in Access but I want to use the name address and postcode as column headings. Any ideas?



 
Old March 19th, 2006, 10:08 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,093
Thanks: 1
Thanked 12 Times in 11 Posts
Default

Can you just select the table and use Table -> Convert -> Table to Text to save the table in correct delimited format.

HTH,

Bob

 
Old March 20th, 2006, 12:59 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,093
Thanks: 1
Thanked 12 Times in 11 Posts
Default

Oops...never mind. See you're using a Word Form. Have only exported Word Form data before. How did your get the format that includes field names?

Bob






Similar Threads
Thread Thread Starter Forum Replies Last Post
Text Import- How to import the first 5 lines. nickzhang.zn Excel VBA 1 August 4th, 2007 05:06 PM
Creating word doc - word behaviour mat41 Classic ASP Professional 2 April 29th, 2007 06:46 PM
How to import word file in Data report in vb Subuana Beginning VB 6 0 April 3rd, 2006 06:20 AM
Import Data from a form to a word package aysha Access 0 April 4th, 2005 09:23 AM
Copy word to word doc. in VB vamshi Pro VB 6 1 March 24th, 2004 06:25 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.