472,336 Members | 1,279 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

home > topics > microsoft access / vba > questions > text file to access table

Join Bytes to post your question to a community of 472,336 software developers and data experts.

Text file to access Table

Hi All
I have a text file which has multiple records. Each part of the record is separated by a comma.
I am trying to import this data to an access table using an upload button for the end user. The end user will use a form to find the file & upload it which will then append the data to an access table. I am getting a Type Conversion Failure error.
I can send text file.
3 Weeks Ago #1
1 6805
isladogs
421 Expert Mod 256MB
Hi
Apologies for the long delay in responding but there was an issue preventing anyone responding until now.
Have you fixed your problem in the meantime, or do you still need help?

If you do still need help, please do upload the text file
4 Days Ago #2

Sign in to post your reply or Sign up for a free account.

Similar topics

3
sql*loader utillity for importing text file into oracle
by: Tomo | last post by:
I'm trying to import text file into some oracle table. I created control file, and text file, create table ..and run sqlldr80 from command promt.....
Oracle Database
2
Exporting Numeric Fields in csv format to a text file
by: Abhishek | last post by:
All, I am trying to export an access table to a text file. This table has a numeric field (Double) and when I export it to a text file, I see the...
Microsoft Access / VBA
9
Append 2nd, 4th, 6th line of a text file to the 1st, 3rd, 5th line as a table
by: carl.barrett | last post by:
Hi, Let me explain. I have been given a file that I need to bring into an Access table. Here is a snippet of the file. 100833983 1 MRS ...
Microsoft Access / VBA
4
Text file access in .NET 2.0
by: Michael A. Covington | last post by:
One of Microsoft's pages says it's easier to read and write text files in ..NET 2.0 than 1.1. It doesn't say what exactly was done (to System.IO or...
C# / C Sharp
3
Import text file to table
by: Dave G | last post by:
I will shortly be receiving data in the form of a text file, like this: id: 123456 first name: Fred surname: Bloggs age: 26 and so on, for...
Microsoft Access / VBA
2
Get and Post data from a text file Access 2007
by: Brad Williams | last post by:
Greetings, I have a Access 2007 App and I want to have a Config File. I have several unbound Text Boxes that are in small Date format that will...
Microsoft Access / VBA
1
inserting column values from text file to table in database
by: phpmel | last post by:
Hi guys, I am new to this stuff and i have NO IDEA what to do. I have a text file where each line is a value for the name of a department.There...
MySQL Database
1
displaying <DIR> in opening text files with table
by: ehcy | last post by:
hello guys.. how can i display the <DIR> in my opened files from my text file with table?.. htmlspecialchars is useless.. it always "Warning:...
PHP
1
Text file having Table data so i want to put this data in to data base in mysql serve
by: murlikrishna | last post by:
in my data.txt file having data that is to be inserted in the data base. i my data.txt file if having more than one row of data then how to do...
Visual Basic .NET
1
Use SELECT INTO in C# to export Access table to csv file
by: MichaelHooker | last post by:
At this topic "https://bytes.com/topic/visual-basic-net/answers/530817-convert-access-table-text-file-using-vb" is the following Q&A:...
C# / C Sharp
0
better678
Discuss your understanding of the Java platform.
by: better678 | last post by:
Question: Discuss your understanding of the Java platform. Is the statement "Java is interpreted" correct? Answer: Java is an object-oriented...
General
0
List of Topmost 8 Electronics Engineering Forum Websites
by: teenabhardwaj | last post by:
How would one discover a valid source for learning news, comfort, and help for engineering designs? Covering through piles of books takes a lot of...
General
0
Benefits of Blockchain App Development for Enterprise Businesses
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
General
0
How to minimize a tool bar that shows up when in reports
by: CD Tom | last post by:
This happens in runtime 2013 and 2016. When a report is run and then closed a toolbar shows up and the only way to get it to go away is to right...
General
0
Basic concepts of WebLogic Admin training?
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
Oracle Database
0
jalbright99669
https redirect with reverse proxy
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
IIS / Internet Information Server
0
How to layout php header location with a variable as the location?
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
PHP
0
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computer
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...
General
0
How do I view Redshift db tables in Alteryx
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...
General

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.

BYTES.COM © 2023
About Bytes
Advertise
Terms Of Use
Privacy Policy

Sitemap

Follow us! Get the Latest Bytes Updates