Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

import multiple text files into access

Comment:

I have multiple text files I am needing to import from a directory. Each file is space delimited and each file has a different number of columns being imported to a different table. each file is named the TABLENAME.txt e.g FILE1.txt COY 012009 78 4598 e.g FILE2.txt 89 789 38762 998 e.g FIILE3.txt 93837 search* 848 more 88754

Name: Jennifer SUMN
Date: August 21, 2009 at 19:07:01 Pacific

Reply:

So what happens when you run the Import Wizard? LIR

0

Getting employee name lis...

Less expensive proprietar...

Summary: I'm trying to set up a macro to import multiple text files into Access 2000. Can you please tell me how to do this. Obviously I can set it up to import a specific file from a directory, but what i w...

Summary: You can import an Excel file into Access. Right click on the white-space in the first window you get and select 'import' this should allow you to chose an Excel sheet. ...

Summary: Hi, Maybe someone can give me advice , I am relatively new to Oracle and I need to load data from a text file into a database table. The format of the file and DB table is below so I would need an ...