Print Page | Close Window

text or Excel to Access

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=10839
Printed Date: 31 March 2026 at 5:13am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: text or Excel to Access
Posted By: Diddl
Subject: text or Excel to Access
Date Posted: 12 June 2004 at 10:40am

Hi Again all.

I'm trying to maintain a lot of lines of information in an Access database - at the moment i'm updating through an asp-page where i manually has to change the records that i want to change... but with more than 1000 records, i wanted to know if anyone could tell me if it's possible to use an Txt-file or Excel file to automatically update the database through an asp-page?




Replies:
Posted By: dpyers
Date Posted: 12 June 2004 at 12:52pm

There's nothing to stop you from reading a text file and updating access with it. You'd have a record on each line with the fields separated by tabs. Use Insrt, Mid, and Split commands to parse each line to extract the fields.

If you have the MS Access program, the task is even simpler as you can copy the text/excel file and paste it at the end of the Access Table. If the copied info contains header rows, the names have to match column names in the db. If no header rows, the fields in the records have to correspond to the sequence of the db columns.



-------------

Lead me not into temptation... I know the short cut, follow me.



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net