Advertisement

02.01.2007 at 09:34AM PST, ID: 22145684
[x]
Attachment Details

VBA To Import Tab Delimited Text File Needed Access 2000

Asked by robotman757 in Microsoft Access Database

Tags: vba, delimited, access, tab, file

I need to write code that will import a file that is tab delimited and also may contain #EMPTY strings that I want removed. I can not use the import wizard because there are several date fields that the wizard never converts and always throws a type conversion error. I used to use Excel first to manipulate the data and then use the DoCmd.TransferSpreadSheet option, but this is no longer possible because my record count is about 150000 records. I just need the methods used to open the file and read the lines and maybe an example of reading the field value and manipulating it before updating in a table.

Thanks!!Start Free Trial
[+][-]02.01.2007 at 09:53AM PST, ID: 18446113

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Microsoft Access Database
Tags: vba, delimited, access, tab, file
Sign Up Now!
Solution Provided By: jimpen
Participating Experts: 1
Solution Grade: A
 
 
[+][-]02.01.2007 at 10:47AM PST, ID: 18446566

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]02.01.2007 at 10:52AM PST, ID: 18446600

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]02.01.2007 at 11:31AM PST, ID: 18446890

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]02.01.2007 at 11:56AM PST, ID: 18447109

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]02.01.2007 at 01:10PM PST, ID: 18447708

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]02.01.2007 at 01:59PM PST, ID: 18448145

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]02.02.2007 at 04:48AM PST, ID: 18451794

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]02.02.2007 at 05:06AM PST, ID: 18451886

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]02.02.2007 at 06:08AM PST, ID: 18452298

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]02.02.2007 at 08:32AM PST, ID: 18453641

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]02.02.2007 at 08:53AM PST, ID: 18453853

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32