Import text files access

Do you need your password? Submit your solution! When answering a question please: Read the question carefully. Understand that English isn't everyone's first language so be lenient of bad spelling and grammar. If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem.

Insults are not welcome. Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question. Let's work to help developers, not make them feel stupid. Related Questions. MS Access data deleted automatically. Importing data from text file and storing it into ms access data base geting only numric data and text is removed. Using the second row of a delimited text file as the header row when importing into Access How to import excel file and save data in access database through VB.

NET by providing excel template. Import text files with variables. Layout: fixed fluid. Web04 2. Strip HTML. Another might be to import the text file, one line at a time, and insert that line into the field in the record for that text file. Was this reply helpful? Yes No. Sorry this didn't help. Thanks for your feedback. Thanks for your reply. I've saved the word doc as a text file, set up a table in Access to receive it in a memo field, then used the ' External data' wizard to choose 'text file'.

In the wizard I've chosen delimited text and the character to delimit the sections of the text I would like as separate records. The source doc is pages. At the finish I'd like each record to be a copy of each section of the original document accepting the limitations of reducing it to Plain Text. I should add that 'line breaks' are necessary to properly structure the text.

Help me here, do the section of text actually include that pipe character? Is that how the WORD doc delimited them? And then try to import that into your Access table. If that doesn't produce the desired result, you will end up importing the text file a line at a time and deciding whether to append it to an existing record or to start a new record.

Thanks for the reply and sorry for the delay. Like Tommy I've had the odd pint of beer, so if I may I'll try this in the morning and get back to you. Still working on it and trying something I found regarding Excel i.

This does give discrete records. The trick in Excel is then to go back into the records and do 'find and replace', reinstating the para marks. Haven't got that to work yet, but do have individual records. It does seem like a bit of a hassle to sort it all out, but when you have the bits and pieces identified you can probably implement a procedure to automate it for future use.

Thanks again for your speedy response and helpful suggestions. Yes the code is exactly how it is vba. The file are located in g:Adminfilenamedate. And the compile error says WHAT. The more info you can provide us the more we can help solve the mystery.

No Account? Sign up. By signing in, you agree to our Terms of Use and Privacy Policy. Already have an account? Sign in. By signing up, you agree to our Terms of Use and Privacy Policy. Enter the email address associated with your account. We'll send a magic link to your inbox. Email Address. All Sign in options. Enter a Email Address. Choose your interests Get the latest news, expert insights and market research, sent straight to your inbox.