Search results for query: *

Hello, I've posted this item before, but no really solutions to solve this. I've some textfiles which i would like to import. In one textfile there are over 1024 columns when separated. This exceeds sql server's maximum columns. Let call this the resultfile. In the other texfile i've got a...

Hi p27br, Thanks for the tip, but it's a little bit to much to understand to get it worked. Can you help me with my code?

...Loop cPrefix = Mid(cPath, nPos + 1, 8) & "_" 'taking the first 8 characters of this folder 'must be the date cFile = Dir(cPath & "*.*") Do Until cFile = "" Name cPath & cFile As cPath & cPrefix & cFile cFile = Dir() 'will return "" when no more files Loop...

Hi, I've a testpackage which i'm trying to adjust. What i would like is to import multiple textfiles (because there are files with the same name) and archive them. The package is from sqldts.com so i'll paste the activex scripts: Script 1 - Defining the Global Variables: Option Explicit...

Hi, Anyone can tell me which accespoint/router is better? I'm thinking to buy the usr805450 (with all turbo related devices )or the linksys new wrt54g speedbooster. I ditched my old wrt54g, because i think usr805450 is better. When i get me one of those models, i also will buy the same brand...

Hi Edwin, Thanks for replying. To answer your questions in your order: 1. Yes, it going to occur on a daily basis. 2. No, because the records should be normalised in the 2 tables which i've created. (e.g.) first table: reference | scandate | scantime | resultnr second table: resultnr |...

Hi Edwin, I tried to do what you said, but i'm having a little bit trouble. I need the columns with the indexnr from the first table to identify the columns in the second and than parse. Can you help me?

Hi Edwin, I did what you suggested. I've two tables where i import the raw data. The first table is structured and contains the columnnames. The second table is the rawdata table with only two columns, one with the form_id (see first message) and second the rawdata. What should i do next? In...

Hello, Can somebody help me with importing directories with their subfolders and files into tables. I would like to query some files with a particular extension and their size to make a capacity calculation.

Hi Edwin, I tried to do what you suggested, but i'm having some trouble with it. I normalized some columns into another table, the rest of the columns needs to be normalized also (like you said by grouping them). In the descriptionfile where the columname is, has also an index. I was thinking...

Hi EdwinGene, I'll try to do what you suggest. Can i return to you if i'm running into problems?

Hello, I've posted this item before, but no really solutions to solve this. I've some textfiles which i would like to import. In one textfile there are over 1024 columns when separated. This exceeds sql server's maximum columns. Let call this the resultfile. In the other texfile i've got a...

Hi, How can i merge data from a database with a postscript? I would like to use a number from the database which in postscript should be formatted as a barcode on a specific location. Now i know it is a programming language, so if it requires some skill then i would like to know what the best...

Hello, How can i schedule to take sql server offline so i can ran defragmentation multiple times at night? I would be very greatful if i know to do this.

Hi Ely, Yes that's basically it. But the fieldnames must be under the field Q Num, like: Q Num Question 1 Question 2 etc.. However fieldnames may vary, so it is not always question1, question2, etc. Can you help me with this?

Hi skip, I really appreciate the help you've given me. I've changed the code a little bit, because i forgot something. The question must also be a fieldname and the value to (see code below). The docmd.runsql still gives me errors about invalid statements. I used debug.print to get some...

Hi Skip, I've removed the cells part but i'm still getting an error message. It seems that the sql is invalid. The errormessage is: expected delete, select, etc.

Hi SkipVought, Thnx for your help, but i've pasted the code in vba in access, but it can't recognize the cells part of the code. Something about sub or function not defined. Is it a code for excell?

Hi, I have table where i have the following fields in datasheetview: id | date | image | question1 | question2 | question..N I would like to have it in this way: id | date | image | questionnr | answer 1 01-01-2004 test.tif 1 1000 (this is the value of field question1)...

Hi, No i do not want to store the carriage return in the database. I'll give you an example. I have table where i have the following fields in datasheetview: id | date | image | question1 | question2 | question..N I would like to have it in this way: id | date | image | questionnr |...