Export From Excel to .txt using Access

[Dugantrain]

Hi, I'm looking to do the following:
Using Access, I'd like to have an Excel Workbook transfer a particular Worksheet to a .txt file. Eventually, I'll be pulling this .txt into Access, but I must first make a detour to Notepad. Going straight from Excel to Access or from Notepad to Access is easy, I just can't find the code to have Access export/import from/to non-Access applications. If noone knows and someone just has the code to transfer from Excel to Notepad from within Excel, then post that and I'll figure out the Automation to make it work from within Access.

 

[Philem]

Hullo. Curious why you need to get it into Notepad first? I normally hear about people trying to get TXT files which "open fine in Notepad" to Excel, so they can do something with it. I'm not saying you don't need to do this, I'm just trying to figure if there is an easier way.

So that this was not a total waste of a reply, I know for certain, and can site code later, that you CAN work directly with TXT files from Access, and I don't just mean importing them, but, treating them as a sort of "flat file" source.

HTH

P

 

[Dugantrain]

Thanks for your reply, Philem. I've posted this question on a couple of different sites and, like yourself, most are curious why I'd want to do such an odd thing:
http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=49356

 

[Parra]

I answered someones question on how to do an excel transfer to access. This is what you have to do, but you need to change some of the options to text.

In a macro in Access
Action: TransferSpreadsheet
Transfer Type: Import
Spreadsheet Type: MS Excel
Table Name: Type name of table in here
File Name: Path eg: c:\my documents\