Recent content by rave

thanks for replying... i am trying to import data from an excel file to an existing table in access using below VBA code. The excel file has around 204 columns 2000 rows currently. I am getting trucation error in last four columns ie. 201, 202, 203 & 204 column.The data type for these column...

I am getting "Trucation Error" while importing data from Excel to access 2007. I have tried changing the format to short text but the result is the same. Can someone help here...

Hi, I am working on a query (given below) where i need to pull data by sector and top # of records from table [APPS UK SALES FLASH MASTER QUERY].[Opty Id]. Also the top # of records will be an input from the user. How do i desigh it? SELECT [APPS UK SALES FLASH MASTER QUERY].[UK Sector]...

hi, i need help! while my tille is confusing.. let me try to explain what am i trying to do here... i have created a cross tab to extract pipeline and sales for Q1 2014, Q2 2014, Q3 2014 & Q4 2014... the user can select the quater from a multivalued text box... Now for the final output...

i am trying to sum three column ie 2013 Q1, 2013 Q2 & 2013 Q4. trying to create a cross tab where i want the total of the 3 qtrs. please guide

Hi all... a quick introduction, this is Ajay from mumbai... working in capgemini into MIS.... having the basic knowledge in access, looking forward to learn and share, hence joining this forum...