Import Text File

**sathishkm** · 07-18-2019, 11:34 AM

Hi All,

I have a text file for more than 50 in a specific path. I want to import all the text files in the access. Is there VBA code to do this job.

Thanks

**queuesef** · 07-18-2019, 12:46 PM

'more than 50' what? files? you maybe able to combine text files using DOS. I believe there was a pipe character that does this? Perhaps the double greater than signs.

**sathishkm** · 07-18-2019, 12:50 PM

50 Text file are in specific path. I want them to import in access database.

**alansidman** · 07-28-2019, 04:36 PM

Do you want them all in the same table or are you wanting to have 50+ tables? Are they all formatted the same? (important if to be consolidated to one table!)

**sathishkm** · 07-30-2019, 08:24 AM

I want them as separate table

**alansidman** · 07-30-2019, 09:09 AM

https://answers.microsoft.com/en-us/...7-8981ff3cd2d6

Import Text File

LinkBack

Thread Tools

Rate This Thread

Display

Import Text File

Re: Import Text File

Re: Import Text File

Re: Import Text File

Re: Import Text File

Re: Import Text File

Thread Information

Users Browsing this Thread

Similar Threads

Import a Text File, via the File Dialog Box, into the Current Workbook's Worksheet1

[SOLVED] Export specific range to text file and import the text file if needed

Import a text file by connecting. Select a file by manual.

[Ask] Import Text file And Call reference path file with Value Range.

[SOLVED] Import text file from VBA code; import all numbers as text

VBA code to import text file to the fixed excel file

[SOLVED] How do I import text file, analyze data, export results, open next file

Bookmarks

Bookmarks

Posting Permissions