de word a bdf

[bellacord]

tengo un gran listado de nombre y telefonos...en extencion .doc, kisiera saber como hacer para importar todo eso a una base de datos...

[Andres95]

Código:

Import a Word text file into Access   

1.	Follow these steps when your Microsoft Word document 
	contains tables, and you want to import those tables 
	into Microsoft Access.

	In Word, save a copy of the file as a comma- or 
	tab-delimited (delimited text file: A file containing 
	data where individual field values are separated by a 
	character, such as a comma or a tab.) unformatted text 
	file. 


	1.1 	If the data is already saved in comma-delimited or 
		tab-delimited format, skip ahead to step 1.3. 
		
	1.2 	If the data is in a table, convert the table to text.

		1.2.1 Select the rows or table (table: One or more 
			rows of cells commonly used to display numbers 
			and other items for quick reference and analysis. 
			Items in a table are organized into rows and 
			columns.) that you want to convert to paragraphs. 
		1.2.2 	On the Table menu, point to Convert, 
			and then click Table to Text. 

		1.2.3	Under Separate text with, click Commas or Tabs. 

	1.3	Make sure the delimited text file has the same type 
		of data in each field and the same fields in every row. 

	1.4	On the File menu, click Save As. 

	1.5	In the File name box, enter a new file name. 

	1.6	In the Save as type list, click Plain Text, and then click Save.
		Note  If you are prompted that formatting will be lost, click OK.


2.	Switch to Microsoft Access, and then open a new or existing database. 

3.	In the Database window, click Tables on the Objects bar. 

4.	On the File menu, point to Get External Data, and then click Import. 
5.	In the Files of type box, click Text Files. 
6.	Click the text file that you want to import, and then click Import. 
7.	Follow the directions in the Import Text Wizard dialog boxes. 


To see more options or to change specifications, such as the field separator 
character (separator characters: Characters you choose to indicate where you 
want text to separate when you convert a table to text, or where you want new 
rows or columns to begin when you convert text to a table.), click Advanced in 
the first wizard dialog box. Doing so starts the Import Specification dialog box. 
To save your new specification for later use, click Save As.

Tomado de la ayuda de word...

un saludo

[bellacord]

pero como es k voy a guardar el documento? eso no lo entendi en la explicacion...

[Andres95]

Bueno si tienes una tabla de word... solo la seleccionas y en el menu Tabla selecciona Convertir y luego seleccionas la opcion Tabla a Texto.

Le puedes das el caracter que requieres para separarlo.. (por ejemplo coma)

luego todos tus elementos quedan asi....cada columna separada por coma..

le das guardar documento como Texto plano y listo...

tienes un txt con la informacion separada por comas...


ya en fox o en access nada mas le das importar archivo... de tipo separado por comas...

:D