Is there a way to upload tab/comma delimited text files into an Access database table that sits up on a server? (Say, I have 500 customer's info in a text file and I don't want to enter them one by one, but I want to load them into an existing table up on the server.)

I have been searching for a solution all over the web, all I could find is solutions for MySQL. Can someone direct me to a tutorial, a tool or some script that can do this in Access?

Thanks

Yes, there is a way.
What you do is import the file by going to the File menu, Get External Data, Import.
Select the file type you wish to import from the Files Of Type drop down (this should be text files for comma delimited) Once you select the file, click ok (or open)
When the Import Text Wizard opens, clico on the Delimited radio button, the next screen select the type of delimiter, (comma or tab)
on the next screen select the name of the table that you want to add the info to, and follow the rest of the wizard.
I do suggest to create a new table and then use an append query to add the info to your actual table.
this may not work the first time, so just keep trying. Remember to do a backup before you try it.





Sal

I am sorry, I might not have been clear on my post. The database would be online up on the server, and I would need to upload multiple records into it through a form. Thus I would not need to download/update/upload the DB all the time.

Currently, I do have a form for submitting new records and updates, but I can do that only one record at a time.

I would need a solution to do more than one at a time. Say, what would be the solution for submitting/importing 500 records at a time.

I am assuming that you are refering to a file that is on a Web Server?
If yes, is this web server a company owned web server where you work or for your web site host?

Please define "Up on a Server"



Sal

This would be a file up on a web site host's server. Not our server.

You may be able to do it through code by creating a front end with a button that uses a specific file name, pre-formatted to meet your criteria. Read the file line by line and assigning each field in the text file to a recordset field.

Not as easy, but once it is done it should work for future uploads.
Your other choice is to bring the database down and do the import.



Sal

Thanks. I think I got the direction... :)