New To UFT? Join the best UFT Training Online!

Micro Focus QTP (UFT) Forums › Micro Focus UFT (earlier known as QTP) › VB Scripting/Descriptive Programming v
Import Excel data to access using VB Script

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Thread Modes
Import Excel data to access using VB Script
Saket Offline
Super Senior Member
*****
Posts: 1,199
Threads: 5
Joined: Nov 2008
Reputation: 0
#2
Not Solved 10-09-2009, 10:37 AM
Not sure,I think, this could be a data issue.
When you import tables from Excel the field length defaults to 255 characters (or 256 bytes). May be with your fields it is going over the limit.
Your need to normalize your data. analyze the data and create multiple tables. Then link to portions of the spreadsheet and append the data correctly to the tables.

Find
Reply


Messages In This Thread
RE: Import Excel data to access using VB Script - by Saket - 10-09-2009, 10:37 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  How to Access MS Excel Controls using QTP gayuamlu 0 2,198 06-13-2015, 02:06 AM
Last Post: gayuamlu
  Search and import data from excel under some rules. nwpulele 2 2,971 02-19-2015, 04:10 AM
Last Post: supputuri
  Excel and Driver Script shipu 1 3,862 02-27-2014, 09:09 AM
Last Post: supputuri
Question QTP Script for enter data to DB geethu105 2 3,338 02-24-2014, 06:54 PM
Last Post: guin.anirban
  How to populate data in weblist using excel vijifun 1 3,351 12-05-2013, 12:06 PM
Last Post: basanth27

Forum Jump:


Users browsing this thread: 1 Guest(s)